Help with mass hiding of rows based on cell value

**J-Fly** · 07-16-2012, 05:40 PM

I am faced with a situation where I need the option to hide many rows with a button. I am unsure how to write the code to trigger a macro that would scan a column and depending on the value detected in each row, that row would be hidden.

IE: it scans Column D for a check-mark or dash. If Row 2 is a dash it is hidden, however if Row 3 is a check mark, it is not.
Additionally, I am not clear on how to create a button that would activate this macro, although I'm sure it is the easy part.

I have attached a dummy workbook for reference to clarify what I am asking help for.

Any help would be greatly appreciated!

Thank you

**Xer2** · 07-16-2012, 06:00 PM

Try this.

Please Login or Register  to view this content.

**AlphaFrog** · 07-16-2012, 06:02 PM

Select column D
Select from the menu Data\Filter\Autofilter
This will put a dropdown list in cell D1
Select from the D1 dropdown list the check-mark character a

This will hide all rows that are not check-marks.

You can record these steps as a macro, or just leave it in AutoFilter mode and make selections from the dropdown list.

**J-Fly** · 07-16-2012, 06:11 PM

This is great!
Quick question though, how did you create that button? And, would there be a way to have a warning message appear before the button is activated? Maybe something that says "Are you sure?"

Originally Posted by Xer2

Try this.

Please Login or Register  to view this content.

**J-Fly** · 07-16-2012, 06:12 PM

Great thought but not exactly what I am looking for. Needs to be pretty much invisible to someone reading it except for the button.

Originally Posted by AlphaFrog

Select column D
Select from the menu Data\Filter\Autofilter
This will put a dropdown list in cell D1
Select from the D1 dropdown list the check-mark character a

This will hide all rows that are not check-marks.

You can record these steps as a macro, or just leave it in AutoFilter mode and make selections from the dropdown list.

**Xer2** · 07-16-2012, 07:30 PM

Change code to this:

Please Login or Register  to view this content.

This new workbook is updated.

Help with mass hiding of rows based on cell value

LinkBack

Thread Tools

Rate This Thread

Display

Help with mass hiding of rows based on cell value

Re: Help with mass hiding of rows based on cell value

Re: Help with mass hiding of rows based on cell value

Re: Help with mass hiding of rows based on cell value

Re: Help with mass hiding of rows based on cell value

Re: Help with mass hiding of rows based on cell value

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions