View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Identifying embedded object # and location

Barb,

You could iterate through all the objects, perhaps, depending on the objects being shapes:

Sub FindD18Shape()
Dim mySh As Shape
For Each mySh In ActiveSheet.Shapes
If mySh.TopLeftCell.Address = "$D$18" Then
GoTo Found:
End If
Next mySh

Found:

MsgBox mySh.Name & " is at " & mySh.TopLeftCell.Address

End Sub

Or you could be more proactive when you insert your objects, and name them when they are inserted,
with names like "objD18"

HTH,
Bernie
MS Excel MVP


"Barb Reinhardt" wrote in message
...
We have an embedded object in our worksheet at location say D18.
Programmatically, how do we identify what object is at that location. There
may be more than one embedded object on the worksheet so how would we address
that?

Thanks