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

Thanks

Sub Last()

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

Jon

Phil Hunt wrote:

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

Thanks





--
42°57N 81°16W

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


"Crash" wrote in message
...
Sub Last()

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

Jon

Phil Hunt wrote:

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

Thanks





--
42°57N 81°16W

set rng = Cells.SpecialCells(xlCellTypeLastCell)

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

--
Regards,
Tom Ogilvy

"Phil Hunt" wrote in message
...
What is the VBA command to find the last cell range on a worksheet?

Thanks

Thanks guy. works great.


"Phil Hunt" wrote in message
...
What is the VBA command to find the last cell range on a worksheet?

Thanks