Hide/unhide specific cells based on the dropdown list value

G

Guest

Hi

I'd like to hide/unhide multiple cells when selecting a certain value in the
dropdown list. All cells are merged cells.

e.g. I have created a cell as a dropdown list containing "group A" and
"group B" using validation. I'd like to hide group B related cells when
"group A" is selected in the dropdown list; and vice-versa.

How can I do this? Any help would be appreciated.
 
T

Tom Ogilvy

Assumed you have named the cells with names to match those in the dropdown
list

for a Data Validation dropdown in Cell A1

Activesheet.Rows.Hidden = False
Range(Range("A1").Value).EntireRow.Hidden = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide Columns based on a Data Validation List 4
Can this be done with HIDE - UNHIDE ? 4
drop down list for IF equation 8
Hide column based on data validation 0
Hide colums based on dropdown list 4
Question on Hide/Unhide cells 4
Dropdown list of hyperlinks 3
HIDE-UNHIDE VBA MACRO 1

Top