Thread: Top left cell in used range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default Top left cell in used range
MsgBox ActiveSheet.UsedRange.Cells(1).Address

is one way.

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

--

Dave Peterson

Reply With QuoteReply With Quote