loop thru auto-filtered list

[Thomas]

Hello,

I've created an excel sheet with machine names in the first column.
When I run my macro it will loop thru all machines and fill the
following columns with the result from a ping to the respective hosts
and some more information from these hosts. In the sheet I use
auto-filter to Display either responsive or non-responsive hosts. Now
my question: Does anybody knows a way to loop thru these auto-filtered
hosts only instead of rescanning the whole lot?

Thanks
Thomas

 

[Thomas]

It is working now. They are always the small things that makes you happy ;-)
Thank you, Bernie.