Hi Tom

Take a look at the code in the FastFilter utility that I wrote, which is
available at
http://www.contextures.com/Fastfilter.zip
or
http://excelusergroup.org/files/fold...entry1194.aspx

Maybe that will help you.
--
Regards
Roger Govier

"Tom" wrote in message
...
Would like to create code which will allow someone to type in a
specific number then would sort the spreedsheet to show just rows
that
have that specific number. I know you can do this with just using the
autofilter drop down, but I want to make it more user friendly buy
just having them type it in a cell then click a button.

Any help would be appreciated.
Tom