Hello everyone,
I know this is an easy code. But the moment i try to use xldown following by offset(1,0) it gives me a runtime error.
Then I found out the cell has reach to the bottom of worksheet (65535).
Is there anyway to rewrite the code so I can get "select the next first blank cell after the last cell used in a column" ?
Thanks in advance.
Hi If your not blank cell is the last cells (65535 row) then how You want select cell under this?
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Does this help:
Range("A65536").End(xlup).Select
xldown works if you have not selected the last cell. Following code is more reliable.
\Joakim
Please Login or Register to view this content.
Last edited by arlu1201; 05-14-2012 at 03:59 AM. Reason: Please put code tags in future.
or this way
p.s. type something in the very last cell (ex 2007) 1048576 row (the results are strange)Please Login or Register to view this content.
Ya, something like this, but how to write the code if I am using "ActiveCell" as a reference?
try..Please Login or Register to view this content.
try
Please Login or Register to view this content.
orPlease Login or Register to view this content.
To select last cell in activesheet in A column you can use this code:
Please Login or Register to view this content.
yes, these are all i am looking for. Thank you everyone!!! :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks