Ура, получилось, большое спасибо!
Вот так прикрутил к своему коду
With sShapes 'Add shape properties
WsNew.Cells(lLoop + 1, 1) = .Name
WsNew.Cells(lLoop + 1, 2) = .OLEFormat.Object.Name
WsNew.Cells(lLoop + 1, 3) = .Height
WsNew.Cells(lLoop + 1, 4) = .Width
WsNew.Cells(lLoop + 1, 5) = .Left
WsNew.Cells(lLoop + 1, 6) = .Top
WsNew.Cells(lLoop + 1, 7) = .TopLeftCell.AddressSub GetShapeProperties()
Dim sShapes As Shape, lLoop As Long
Dim wsStart As Worksheet, WsNew As Worksheet '''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''LIST PROPERTIES OF SHAPES''''''''''''' ''''''''''Dave Hawley www.ozgrid.com'''''''''''' ''''''''''''''''''''''''''''''''''''''''''''''''
Set wsStart = ActiveSheet
Set WsNew = Sheets.Add 'Add headings for our lists. Expand as needed
WsNew.Range("A1:G1") = _
Array("Shape Name", "Shape Type", "Height", "Width", "Left", "Top", "Adress") 'Loop through all shapes on active sheet
For Each sShapes In wsStart.Shapes 'Increment Variable lLoop for row numbers
lLoop = lLoop + 1
With sShapes 'Add shape properties
WsNew.Cells(lLoop + 1, 1) = .Name
WsNew.Cells(lLoop + 1, 2) = .OLEFormat.Object.Name
WsNew.Cells(lLoop + 1, 3) = .Height
WsNew.Cells(lLoop + 1, 4) = .Width
WsNew.Cells(lLoop + 1, 5) = .Left
WsNew.Cells(lLoop + 1, 6) = .Top
WsNew.Cells(lLoop + 1, 7) = .TopLeftCell.Address
End With
Next sShapes 'AutoFit Columns.
WsNew.Columns.AutoFit
End Sub