View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick A[_2_] Rick A[_2_] is offline
external usenet poster
 
Posts: 7
Default Work wil rows returned from AutoFilter

How do I capture the range of cells displayed after performing an AutoFilter?

In my spreadsheet I filter for a specific value in a specific column. After the filter runs the rows that are returned are not continuous. I need to look at each returned row and perform some work on cells in that row.

I thought about walking through the list but I do know how to determine where to star and what do to when the numbers are not continuous. This seems easy enough because I can do this manually. I need a kick start to understand how to do this in code.

If this makes sense any help would be appreciated.

--
Rick A