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:
LastCellValue = Range("A5:T10").Find("*", , xlValues, xlWhole, , xlPrevious, , , False).Value
but how can I return which cell it is sitting...