| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I hide rows in excel based on values input on sheet ?
need to hide certain rows based on values entered elsewhere on the sheet -
please assist |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I hide rows in excel based on values input on sheet ?
in VBA: Code ------------------- If Cells(1, "A") = "ValueToTestFor" Then Cells(2, "B").EntireRow.Hide = True Else Cells(2, "B").EntireRow.Hide = False End I ------------------- Replace the cell addresses with the respective cells -- ph ----------------------------------------------------------------------- ph8's Profile: http://www.excelforum.com/member.php...fo&userid=1987 View this thread: http://www.excelforum.com/showthread.php?threadid=52484 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide rows in an Excel worksheet based on a variable | Excel Discussion (Misc queries) | |||
| Code to hide tabs based on input | Excel Discussion (Misc queries) | |||
| Moving data in one excel column to another sheet based on user input | Excel Discussion (Misc queries) | |||
| Can visual basics hide rows based on cell values? | Excel Discussion (Misc queries) | |||
| Automate display/ hide rows in excel based on yes/no check box | Excel Discussion (Misc queries) | |||
Linear Mode
