If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatically hide/unhide rows
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 | |
Display Modes | |
|
|