ExcelBanter - AUTO HIDE ROWS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - AUTO HIDE ROWS (https://www.excelbanter.com/excel-worksheet-functions/7146-auto-hide-rows.html)

Alan

AUTO HIDE ROWS

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

Ron de Bruin

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

All times are GMT +1. The time now is 12:46 PM.