Hello,
I have a column containing names of suppliers. I sort the column and want
to quickly find the range containing the name of specific supplier (e.g,
Supplier A) and select that range. Is there a quick way of doing this?

Thanks

Bill

Data=Filter=Autofilter

If you need code, turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy

"Bill" wrote in message
k.net...
Hello,
I have a column containing names of suppliers. I sort the column and want
to quickly find the range containing the name of specific supplier (e.g,
Supplier A) and select that range. Is there a quick way of doing this?

Thanks

Bill