LinkBack URL
About LinkBacks
Hello Gurus,
I'm having a problem when selecting the last row of Column A. I'm using the below code and it gives me an error 'Object required' in the highlighted line.
Please Login or Register to view this content.
Hello Gurus,
I'm having a problem when selecting the last row of Column A. I'm using the below code and it gives me an error 'Object required' in the highlighted line.
Please Login or Register to view this content.
change your line to
.Range("A" & .Rows.Count).End(xlUp).Select
Thanks Jijenn!
IF the last row of column A is A50, how can i select A51?
.Range("A" & .Rows.Count).End(xlUp).Offset(1,0).Select
I've now figured it out.
Thanks again Jiejenn!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks