Excel AutoFilter - Only filtered values

[jhtromb]

Hello,

I need to read some lines from an excel file that works with filter and write the values into an array.

My problem is: if I use the Excel UDF the script reads every line (there are more than 3.000), but I only need the filtered lines (around 150).

Is it possible to take the filtered lines into consideration only?

Thank you in advance!

[water]

Loop through the cells and check the hidden attribute as described here.

Or use method intersect to get the visible rows as described here.

[Juvigy]

or something like that;

$oExcel = _ExcelBookAttach("Startup.xlsb", "FileName")

$rng = $oExcel.Application.Activesheet.Autofilter.Range.Columns(2)

$rng = $rng.Offset(1,0).Resize($rng.rows.count -1,1)

$rng1 = $rng.SpecialCells(12)

$i=0

Dim $Array[$rng.SpecialCells(12).count]

For $element in $rng1

$Array[$i] = $element.value

$i=$i+1

Next

_ArrayDisplay($Array)

[jhtromb]

Thank you for your suggestions!

I solved it in another way by just selecting all cells and copying them to a new sheet. This only copies the filtered values.