Top left cell in used range

Chris Gorham · Dec 24, 2003

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

Dave Peterson · Dec 24, 2003

MsgBox ActiveSheet.UsedRange.Cells(1).Address

is one way.

J.E. McGimpsey · Dec 24, 2003

One way:

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

pfsardella · Dec 24, 2003

ActiveSheet.UsedRange.Cells(1,1).Address

HTH
Paul

Tom Ogilvy · Dec 24, 2003

or even

Activesheet.UsedRange.Item(1).Address
or

ActiveSheet.UsedRange.Item(1,1).Address