H
hheckner
Hi,
I want to iterate through all rows which are currently visible with an
activated autofilter.
I tried the Range Autofiler.Range but that gave me all rows in (also
the ones which are not visible!)
then i tried: Set oRng = AutoFilter.Range.Cells.SpecialCells
(xlCellTypeVisible) but that gave me only 1 row (I think it will be
the title line).
What I want to do ist
do while ' there are more rows available through the autofilter result
' work on the rows which are visible through the autofilter
loop
I am not interested in the setting filter criterias through my macro!
Any help on this one greatly appreciated
Best regards
Hannes
I want to iterate through all rows which are currently visible with an
activated autofilter.
I tried the Range Autofiler.Range but that gave me all rows in (also
the ones which are not visible!)
then i tried: Set oRng = AutoFilter.Range.Cells.SpecialCells
(xlCellTypeVisible) but that gave me only 1 row (I think it will be
the title line).
What I want to do ist
do while ' there are more rows available through the autofilter result
' work on the rows which are visible through the autofilter
loop
I am not interested in the setting filter criterias through my macro!
Any help on this one greatly appreciated
Best regards
Hannes