Hide Blank Rows based on 2 columns

**yzer19** · 01-05-2008, 04:05 PM

I have a bit of code that I used a while back but need to tweak it. The code currently works well and hides the blank rows at the bottom of a single column range. This is what I need now:
-I want the code to look at the data in BOTH columns C and D. Then hide the rows that are below the last line whether its in column C or D. I have tried just changing the Range in the code but that doesn't seem to work. Any help would be great.
Thanks
Rob

Please Login or Register  to view this content.

**rylo** · 01-06-2008, 02:38 AM

Hi

Try

Please Login or Register  to view this content.

rylo

**yzer19** · 01-06-2008, 09:25 AM

Thanks Rylo - you came to rescue again.

**VBA Noob** · 01-06-2008, 09:47 AM

So why did you cross post it then.

Please read forum rules and message to cross posters below and then add the loink to the other forum

VBA Noob

**yzer19** · 01-06-2008, 10:00 AM

Your right my mistake, her is the link to the other forum. Won't happen again.

http://www.mrexcel.com/forum/showthr...=1#post1454177

**royUK** · 01-06-2008, 11:23 AM

Just change the range

Please Login or Register  to view this content.

Hide Blank Rows based on 2 columns

LinkBack

Thread Tools

Rate This Thread

Display

Hide Blank Rows based on 2 columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions