Thread: refering to worksheet cell under shaoe object
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
  
Posts: 5,600
Default refering to worksheet cell under shaoe object
Hi David

With ActiveSheet.Shapes(1)
MsgBox .TopLeftCell.Address, , .Name
End With

Regards,
Peter T

"David" wrote in message
...
TIA for your time
Is there a way to ask a shape object which worksheet cell it is positioned
over?
--
David


Reply With QuoteReply With Quote