Sub GetShapeProperties() Dim sShapes As Shape, lLoop As Long Dim ws1 As Worksheet Set ws1 = Worksheets("sheet1") 'Add headings for our lists. Expand as needed ws1.Range("A1:C1") = _ Array("Shape Name ", "Height", "Width") 'Loop through all shapes on active sheet For Each sShapes In ws1.Shapes 'Increment Variable lLoop for row numbers lLoop = lLoop + 1 With sShapes 'Add shape properties ws1.Cells(lLoop + 1, 1) = .Name ws1.Cells(lLoop + 1, 2) = .Height ws1.Cells(lLoop + 1, 3) = .Width 'Follow the same pattern for more End With
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)