Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto adjusting # rows between 2 worksheets | New Users to Excel | |||
CAN I HIDE ROWS WITH CONDITIONAL FORMATTING? | Excel Discussion (Misc queries) | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
Macro to hide rows with empty cells | Excel Worksheet Functions | |||
Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions |