Last Cell on a Worksheet

[DavidW]

I would like to get the last cell used on a worksheet and place it in
variable. I would like for the last cell address to be in the forma
with a letter as column and an integer as row. For example: if the las
row is L257, I would like it to be stored in the variable as L257 rathe
than as an integer. I know how to find the last cell and display it in
message box after finding integer values of the last row and column. Th
following will display the last cell as $L$257:

MsgBox Cells(LastRow, LastColumn).Address

Can I place that value in a cell as L257? Or can someone point me t
some code that will get the last cell in that format?

Thanks. I know this is easy

 

[Bob Phillips]

MsgBox Cells(LastRow, LastColumn).Address(False,False)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)