Thread: Complicated VBA? Moving filtered data....
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
  
Posts: 274
Default Complicated VBA? Moving filtered data....

TomorrowsMan,

A couple of suggestions:

1) Copy/Paste filtered rows to another sheet, delete blank rows, loop
thru and do whatever

Or

2) Loop through filtered range and testing to see if cell/ row .visible
property = True, if it is do whatever.

Regards

Michael Beckinsale

Reply With QuoteReply With Quote