Have a look in vba help index for SPECIALCELLS (xlvisible)

--
Don Guillett
SalesAid Software

"Rick A" wrote in message ...
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