Hi Alan

With VBA code it is possible to do a auto hide but maybe you
can use Autofiltercustom to do what you want

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alan" wrote in message ...
Is there a method/function to auto hide rows dependent on the value of a cell
in that row ...

Ie cell B3 = 0 ...... hide row ??!

Many thanks again

Alan