get cell 'address' from last value in range...

[RobbieC]

Hi there, I have a range A5:T10. I'm looking to find the address of the cell containing the last value.

I can find the last value in the range by using:

[COLOR=#333333][FONT=monospace]LastCellValue = Range("A5:T10").Find("*", , xlValues, xlWhole, , xlPrevious, , , False).Value

but how can I return which cell it is sitting in ie. L7

If you can point me in the right direction I'd be very happy

Thanks[/FONT][/COLOR]

 

[steve the fish]

Instead of .Value use .Address(0,0)

 

[Fluff]

How about

Dim adr As String
adr = Range("A5:T10").find("*", , xlValues, xlWhole, , xlPrevious, , , False).Address(0, 0)

 

[RobbieC]

Thanks guys, that was just the ticket! Works perfectly!

 

[Fluff]

Glad we could help & thanks for the feedback