billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Hello all
Is there a difference or efficient way to find the last data in a column of the two. In the Forum I see both methods used.
Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Sheet1").cells(Rows.Count, 1).End(xlUp).row
Is there a difference or efficient way to find the last data in a column of the two. In the Forum I see both methods used.
Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Sheet1").cells(Rows.Count, 1).End(xlUp).row