Try using the Autofilter under the Data=Filter menu. If you need code,
turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy

wrote in message
...
Is there a way to construct a 'search' input box that acceps a string (eg
BoatName='OceanDance') and a column paramter eg (Column=C) and then
returns
the rows relating to that user criteria....

Very much appreciated
Jason