UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> VBA to select the last entry in a list - even if there are blank    
 
   
Wmat232
post Aug 19 2003, 01:34 PM
Post#1



Posts: 113
Joined: 6-March 03
From: Texas


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.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    14th December 2017 - 09:42 PM