View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] NoSpam@aol.com is offline
external usenet poster
 
Posts: 142
Default Macros with AutoFiltering

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