Getting data from an Excel sheet into an array is usually best accomplished with a statement that looks something like this:
vMyArray = Sheet1.UsedRange.Value
I thought it would be keen to fill an array from a filtered list, so I coded
Sub ArrFilteredList()
Dim vArr As Variant
vArr = Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).Value
[...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/03/08/getting-array-data-from-a-filtered-list-in-vba/
Posted
Mar 08 2010, 04:50 PM
by
Daily Dose of Excel