swjtx99
asked on
Select A2 to Last populated cell in column A using one line of code
Hi,
Can't seem to find a "one line of code" solution to selecting A2 to last populated cell in Column A.
I thought this should work but it doesn't.
Range("A" & Range("A" & Rows.Count).End(xlUp).Row) .Select
Thanks
swjtx99
Can't seem to find a "one line of code" solution to selecting A2 to last populated cell in Column A.
I thought this should work but it doesn't.
Range("A" & Range("A" & Rows.Count).End(xlUp).Row)
Thanks
swjtx99
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Fair enuf, swjtx.
Yes, googling for something as specific as this can be a waste of time, sometimes.
Thanks for the points.
tel2
Yes, googling for something as specific as this can be a waste of time, sometimes.
Thanks for the points.
tel2
ASKER
Have to give the edge to Rgonzo1971.
Amazing how many hours of google searching didn't return this answer.
swjtx99