Macro to Hide/Unhide Multiple Rows Based on Cell Value

**mbp727** · 05-14-2013, 11:07 AM

I have a sheet with regions listed and a selector to choose whether or not to "enable" the region. If "yes" is selected, the value 1 is returned, if "no" is selected the value 0 is returned.

I want to write the macro like the one below, but instead of listing the rows as ranges I need to refer to multiple, specific rows. Ex. 15, 18, 23.

Please Login or Register  to view this content.

Thanks

**ragavan.sridar1** · 05-14-2013, 12:47 PM

Try it like this..

Please Login or Register  to view this content.

**mbp727** · 05-17-2013, 11:12 AM

This allowed me to hide the cells but excel crashes when the macro runs because it's so slow. Is there a way to code this w/o select?

Macro to Hide/Unhide Multiple Rows Based on Cell Value

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Hide/Unhide Multiple Rows Based on Cell Value

Re: Macro to Hide/Unhide Multiple Rows Based on Cell Value

Re: Macro to Hide/Unhide Multiple Rows Based on Cell Value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions