Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,888
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
Hi All
I thought this would be a lounge type question.
I have noticed over some time that many users have a different spin on finding the last row.
I was wondering which is the fastest, most efficient, etc.
I use:
while others use:
and some are still using the range reference of 65000, or 1 million now.
It probably makes bugger all difference, but it has been *****ing my curiosity
Regards
Michael M
I thought this would be a lounge type question.
I have noticed over some time that many users have a different spin on finding the last row.
I was wondering which is the fastest, most efficient, etc.
I use:
Code:
Lrow=Cells(Rows.Count,"A").End(xlUp).Row
while others use:
Code:
LR = Range("A" & Rows.Count).End(xlUp).Row
It probably makes bugger all difference, but it has been *****ing my curiosity
Regards
Michael M