How do i find the last cell range in a sheet

[Phil Hunt]

What is the VBA command to find the last cell range on a worksheet?

Thanks

 

[Crash]

Sub Last()

MsgBox "Last cell is " & _
ActiveSheet.UsedRange.SpecialCells(xlLastCell).Address
End Sub

Jon

 

[Phil Hunt]

That was quick. I may have more question later. This is my first time
programming Excel

 

[Tom Ogilvy]

set rng = Cells.SpecialCells(xlCellTypeLastCell)

finds the lower right corner of the usedrange. It may not be what you
expect however.

 

[Phil Hunt]

Thanks guy. works great.