Select last cell before blank, then offset

Hello,

I have this simple code which selects the last cell before a blank.

Please Login or Register  to view this content.

My initial goal was to select the blank cell itself.

I've tried adding numerous variations of (offset=-1), with little luck.

What can I add which will offset the selection 1 cell down to select the blank cell?


Thanks for any help.

Jeff

Hello Jeff.p,

Start at the end of the worksheet and move up. Some people use 65536 in place of Rows.Count. Excel 2007 supports more than 65536 rows. This way works for all versions.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks, Leith for the reply,


Sadly I'm receiving this error.

compile error
Expected End Sub



Tried adding an End Sub, but no luck

any ideas?

...just figured it out.

Please Login or Register  to view this content.