View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales K Dales is offline
external usenet poster
 
Posts: 131
Default 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


.