Initialize array from cell values in a column...

...where certain cells might be hidden. This returns only the first value (instead an array of all values). How do I get around that one?

Please Login or Register  to view this content.

Thanks!

Hi,
I tried your code and it seems to work fine. I can get an array of 1048576 rows x 1 column contain the hidden cells. But, without seeing your workbook, difficult to say if I test in the same conditions...

do you really need to pass the EntireColumn in the array. Why not only the current region, assuming data starts in row 1

Please Login or Register  to view this content.

or by finding the lastrow with a value in your column :

Please Login or Register  to view this content.