Hi there,

Yes I actually came up with a very similar type of code myself.
But I was wondering if there was a way to get the resultset from the Autofilter itself.
SO I guess my question is:

"Can AutoFilter pass back a resultset or an Array with the results?"

Is there some method/function that it has that can do this so that one can avoid
looping thru a range and using conditional IF statements.

Thanks for your solution, it is more compact than my solution(in the looping way).

Thanks again.

Sincerely,

Paluee