Sub Find_Image_Range_In_Excel()
Dim sht As Worksheet
Dim shp As Shape
For Each sht In Sheets
For Each shp In sht.Shapes
MsgBox "Shape Extends from ( " _
& shp.TopLeftCell.Row & "," & shp.TopLeftCell.Column & ") to (" _
& shp.BottomRightCell.Row & "," & shp.BottomRightCell.Column & ")"
Next
Next sht
End Sub
thanks for your help huutruong
ReplyDelete