Solved Macro or VBA input to unhide a row based on input

March 7, 2018 at 03:06:52
Specs: Windows 7
I have a sheet wherein I need a row unhid if a user chooses "Yes" from a drop down list. Can someone please help get a formula for this?
I have been trying to get my head around VBA but hitting dead ends.

message edited by learnexcel


See More: Macro or VBA input to unhide a row based on input

Report •

#1
March 7, 2018 at 03:58:27
There is no formula that can hide or unhide a row. You need to use VBA.

If you'll provide some specifics as to what you are trying to do, we'll see if we can help.

Where is the Drop Down, what row needs to be unhid, etc. The more details you provide, the closer we can get to a final solution.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#2
March 7, 2018 at 04:05:56
The sheet has a row 39 , with a drop down in cell E39
If E39 is chosen as YES from the drop down, I want the contents in row 39 to be replicated below it.
I thought the easiest would be to unhide an existing row. If replicating is easier that would be fine as well.
Sorry if I'm over complicating things :)

Report •

#3
March 7, 2018 at 05:46:09
✔ Best Answer
There is a big difference between unhiding an existing row and replicating a current row.

To replicate a row, the code would basically perform a Copy/Insert Copied Cells operation. To unhide an existing row, the code would basically perform an Unhide operation.

From a coding perspective, the level of difficulty is a wash. However, from a set-up perspective, the data would already have to be in the hidden row in such a manner that it matches the "Yes" row once it's unhidden. That sounds like more prep work.

Bottom line is that you need to tell me what works best for you and your work process.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Related Solutions


Ask Question