Creating array of visible (filtered) rows in excel

[stupomer]

Hi Gintaras (and others),
I have a very large excel sheet (~30k rows), and I want to run a process on only the rows that are visible after a filter is applied. Ideally, there would be some way to have a single dimensional array of visible rows (or can do a <sel> range if I select after doing the filter. Then I could do something like

Code:

Copy      Help

ARRAY(int) FilteredRows
[some function to fill array with row numbers of visible/filtered cells]
for _i 0 FilteredRows.len
,if !empty(es.Cell(1 FilteredRows[i])) 
,,es.SetCell(2 FilteredRows[i] "not empty"

I saw something like this 

Code:

Copy      Help

Excel.Range r=es._Range("<sel>")

which would work I think if I select the visible rows after filter applied, but now sure how to use the Range object like an array.

Thanks for any thoughts!,
S