Help with hiding or unhiding multiple ranges of rows based on cell value on another sheet

**Jake Bierly** · 07-22-2013, 11:00 AM

Hello all,

I currently have a macro that auto-filters information on a sheet (Sheet1) based on a drop-down selection. I now need to modify this macro or create an additional macro that will hide two ranges of rows on a second sheet (Sheet2) based on the same drop-down. The current auto-filter is:

Sub DropDown2_Change()

Sheets("Page 2").Range("A9").AutoFilter Field:=1, Criteria1:=Cells(Cells(3, 19).Value, 19).Value

End Sub

Can anyone show me how to modify the above macro to hide rows 100:120 and 160:180 on sheet2 based on the drop-down (value in cell S19) on sheet1?

I'm fairly new to this so any help at all would be greatly appreciated.

Thanks,

Jake

**JosephP** · 07-22-2013, 11:01 AM

what do you mean by 'based on the drop-down value'? what determines hidden vs visible?

**Jake Bierly** · 07-22-2013, 11:04 AM

The drop-down menu only contains two choices. One of the choices generates a "1" and the other a "2" in cell S19 on sheet one. I want to hide the rows I referenced in sheet 2 if the value in cell S19 on Sheet1 is a "1".

Thanks for your help!

**JosephP** · 07-22-2013, 11:07 AM

add

Please Login or Register  to view this content.

**Jake Bierly** · 07-22-2013, 11:29 AM

So sorry - I made a few errors when describing the details. The ranges are different and I changed the condition in cell S3, not S19 on sheet "Page 2" to the value "2".

I added the code but modified the sheet name after I realized I had changed it. There are no errors when running but the rows do not hide when cell S3 on sheet "Page 2" = 2.

Please Login or Register  to view this content.

I appreciate the help.

**JosephP** · 07-22-2013, 11:39 AM

perhaps you could post a workbook-I'm no longer sure where anything is!

**Jake Bierly** · 07-22-2013, 11:56 AM

Sure. Sorry for the confusion. I've uploaded an example of what I was talking about. I'm trying to hide the ranges I mentioned before based on the Residential or Commercial drop-down. I want to hide rows 110:116 and 128:136 on the "CF" tab when "Commercial" is selected on the "Page 2" tab.Filter Code.xlsm

**JosephP** · 07-22-2013, 12:03 PM

gotcha-that line oughta be

Please Login or Register  to view this content.

**Jake Bierly** · 07-22-2013, 12:14 PM

Works flawlessly. Thank you so much for your help.

Help with hiding or unhiding multiple ranges of rows based on cell value on another sheet

LinkBack

Thread Tools

Rate This Thread

Display

Help with hiding or unhiding multiple ranges of rows based on cell value on another sheet

Re: Help with hiding or unhiding multiple ranges of rows based on cell value on another sh

Re: Help with hiding or unhiding multiple ranges of rows based on cell value on another sh

Re: Help with hiding or unhiding multiple ranges of rows based on cell value on another sh

Re: Help with hiding or unhiding multiple ranges of rows based on cell value on another sh

Re: Help with hiding or unhiding multiple ranges of rows based on cell value on another sh

Re: Help with hiding or unhiding multiple ranges of rows based on cell value on another sh

Re: Help with hiding or unhiding multiple ranges of rows based on cell value on another sh

Re: Help with hiding or unhiding multiple ranges of rows based on cell value on another sh

Thread Information

Users Browsing this Thread

Similar Threads

Hiding and unhiding worksheets based on a cell value from another worksheet

[SOLVED] Hiding/Unhiding Rows Based on Dropdown Box

[SOLVED] Hiding / unhiding pictures based on cell value

Hiding Unhiding Rows based on Text condition

Hiding / Unhiding rows when multiple cell values change

Bookmarks

Bookmarks

Posting Permissions