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
|