Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft Excel FAQs _ VBA to select the last entry in a list - even if there are blank

Posted by: Wmat232 Aug 19 2003, 01:34 PM

If you need to get to the bottom of a list which may contain blanks, use the following line of code:
Range("A65536").End(xlup).Select
FOr to choose the first new cell below that one:
Range("A65536").End(xlup).Offset(1,0).Select
Hope this helps somebody.