If you record the macro on the earliest version of Excel that will need to
use it, you should have no problems.

As recorded, the macro will need to be enhanced to allow dynamic selection
of a value - using the inputbox function as an example and substituting the
result in the Autofilter command.

Or you might find that instructing your users how to use Autofilter may
eliminate the need for macros.

--
Regards,
Tom Ogilvy


wrote in message
...
Will these macros work across all machines.....?

Isn't there a problem with mouse vs keystroke macros...

Many thanks
Jason
"Tom Ogilvy" wrote in message
...
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