Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm a VBA newbie and have searched for an answer for how to do this, but must
be doing something wrong when I've tried other codes. I need to have rows automatically hide or unhide based on a value in column D. If the value in column D is Y, the row should not be hidden; if the value is N, the row should be hidden. These values may change, so the rows need to be able to hide/unhide automatically. When I've entered codes in before, I click on the tab for this worksheet, select View Code, choose Insert Module, and then insert the code. There is already a code in this worksheet for something else, so I can't just add it in after selecting View Code. Am I putting the code in the wrong spot? Should I be choosing something else other than Insert Module? I've tried out so many different codes thinking that was the problem, but now I think I may just be entering it wrong. I appreciate your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
How to Hide and Unhide Rows | Excel Discussion (Misc queries) | |||
Automatically hide/unhide columns | Excel Discussion (Misc queries) | |||
CONDITIONAL HIDE/UNHIDE ROWS | Excel Discussion (Misc queries) | |||
Hide Unhide Rows | Excel Discussion (Misc queries) |