Macros with AutoFiltering
Check the row height - filtering just sets the height to
zero to hide the row.
For i = 1 to nRows
If Sheets(MySheet).Rows(i).RowHeight 0 Then...
Next i
-----Original Message-----
If I have Autofiltering turned on, how can I tell from
within a macro which
lines are selected?
for i = 1 to nRows
if row i is displayed then ....
next i
.
|