RawlinsCross
Active Member
- Joined
- Sep 9, 2016
- Messages
- 437
So this is the oldest (or one of them) trick in the book with
But what I'm working with is a column number (say 15). Can I use the number 15 directly and try to look for the last row containing data? Or do I need to convert it to a letter first?
John
VBA Code:
lRow = ThisWorkbook.Worksheet("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
But what I'm working with is a column number (say 15). Can I use the number 15 directly and try to look for the last row containing data? Or do I need to convert it to a letter first?
John