Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding rows based on cell contents
I want to hide certain rows in one worksheet based on the value from another
worksheet. For example, hide rows 1-10 based on the value of FALSE in cell A1 from the other worksheet. I am assuming VBA code is needed, but I am not that familiar with VBA other than creating simple macros. Any help would be greatly appreciated!! Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding rows based on cell contents
Hi Jason
Try Sub hiderows() Sheets("Sheet1").Rows("1:10").EntireRow.Hidden = False If Sheets("Sheet2").Range("A1") = False Then Sheets("Sheet1").Rows("1:10").EntireRow.Hidden = True End If End Sub -- Regards Roger Govier "Jason M" wrote in message ... I want to hide certain rows in one worksheet based on the value from another worksheet. For example, hide rows 1-10 based on the value of FALSE in cell A1 from the other worksheet. I am assuming VBA code is needed, but I am not that familiar with VBA other than creating simple macros. Any help would be greatly appreciated!! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I conditionally delete rows based on cell contents? | Excel Worksheet Functions | |||
Can visual basics hide rows based on cell values? | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Delete row based on contents of cell | Excel Discussion (Misc queries) |