When declaring an array in VBA, you typically set its size at the beginning, like Dim myArray(1 To 5). However, there are many situations where you don't know how many array elements you need until ...

So, I am writing an application in Excel2000 and VBA. I am using Autofilter to go through a bunch of raw data in a worksheet, filter it out, and copy it to a new sheet. For example, I have a sheet ...

Actually, the biggest reason for slow VBA is often the number of times it accesses cells. In this article, I will explain why reducing cell access speeds up your code, the mechanism behind it, and ...