One way:

Dim sAddress As String
sAddress = ActiveSheet.UsedRange.Cells(1).Address


In article ,
"Chris Gorham" wrote:

Hi,

can somebody tell me how to find the address of the top
left cell for the used range on a worksheet..??


Sorry, I know this is trivial...

Chris