Thread: Top left cell in used range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Top left cell in used range
or even

Activesheet.UsedRange.Item(1).Address
or

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

--
Regards,
Tom Ogilvy

"Chris Gorham" wrote in message
...
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


Reply With QuoteReply With Quote