End right Skip Blanks

**SystemsAccountant** · 11-26-2008, 06:23 AM

Hi,

I have a range I would like to select but this includes blanks. I would like the VB to skip these blanks and find the last value / text in this row and then select that entire row.

Here is part of the code I have:-

Please Login or Register  to view this content.

This only goes until the first blank......

Help greatly appreciated

Kind Regards
Matthew

**royUK** · 11-26-2008, 06:27 AM

Remember you do not generally need to select ranges

Please Login or Register  to view this content.

**Richard Schollar** · 11-26-2008, 06:28 AM

Hi Matthew

You can go in the reverse direction:

Please Login or Register  to view this content.

Richard

**SystemsAccountant** · 11-26-2008, 07:03 AM

Thanks Both.

I opted to go with Richards solution as I understand that one more at the moment.

Matt

End right Skip Blanks

LinkBack

Thread Tools

Rate This Thread

Display

End right Skip Blanks

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions