Finding last used row in non-contingous data using column number (not letter)

[RawlinsCross]

So this is the oldest (or one of them) trick in the book with

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

 

[MARK858]

You're welcome (but your thanks should go to Rory... he wrote the blog)