Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What I'm trying to achieve is the automatic hiding of entire rows if the
value of a cell, in this case in column B, is < 1. The below example works...row 6 is hidden. Sub hide_row() If Range("B6").Value < 1 Then Range("B6").EntireRow.Hidden = True End Sub But when I try to impose this upon a range of column B, then, alas, not the desired result! If Range("B6,B9").Value < 1 Then Range("B6,B9").EntireRow.Hidden = True Can anyone point me in the right direction? Thanks in advance! Al |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro/code to hide rows | Excel Worksheet Functions | |||
Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
hide rows with macro | Excel Discussion (Misc queries) | |||
macro to hide rows | Excel Discussion (Misc queries) |