Need to tweak code...Hide Rows Based on Cell Value

**kmlloyd** · 07-17-2015, 10:03 PM

I have the code below hiding columns based on the value in the respective cells.

Now I need to adjust this so it will also hide rows A9:A16 based on their cell values. They will either be blank or will say "HIDE" if that row needs to be hidden.

Please Login or Register  to view this content.

**alansidman** · 07-17-2015, 10:37 PM

Try this:

Please Login or Register  to view this content.

**kmlloyd** · 07-21-2015, 01:05 AM

Thank you. When I use this, it seems to get caught up on something...it's "skipping" like it's trying to do something and then it gets stuck there until I hit Esc and end the execution.

When I hit Debug, the first instance of "Next rCell" is highlighted.

**kmlloyd** · 07-21-2015, 11:05 AM

Got it solved:

Please Login or Register  to view this content.

Need to tweak code...Hide Rows Based on Cell Value

LinkBack

Thread Tools

Rate This Thread

Display

Need to tweak code...Hide Rows Based on Cell Value

Re: Need to tweak code...Hide Rows Based on Cell Value

Re: Need to tweak code...Hide Rows Based on Cell Value

Re: Need to tweak code...Hide Rows Based on Cell Value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Hide rows based on cell value - VBA code

Looking for a VBA code to hide rows based on a single cell value

Help: Code to hide multiple rows based on different cell values

VBA code to hide/show rows based on value in each row

Code to show/hide rows based on Y

Modify code to hide rows based on the contents in a cell.

Bookmarks

Bookmarks

Posting Permissions