Format Images - Range of Image
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
Friday, May 04, 2007
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
thanks for your help huutruong
ReplyDelete