VBA: Filter issue and loop through all items in that fillter

[sunilbsrv2k]

Hi All,

I have a question on Filters in VBA.

I want to create a filter on a particular column; this is accomplished using the regular code.
However the issue is, I need to create a loop to select each item in the filter and do some tasks. Is this possible?

To simplify this, I have four names Name1, Name2, Name3 and Name4 in a Table column. It contains several rows of data but all having any one of these names. If I create a filter on this column, I should be able select Name1 once, then Name2 then Name3 and finally Name4... And finally work on the data.. Is it possible to do this?

Please help