View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Checking for a picture


Sub test4()
For Each pict In ActiveSheet.Shapes
firstrow = pict.TopLeftCell.Row
firstcolumn = pict.TopLeftCell.Column
myheight = pict.Height 'pixiles
mywidth = pict.Width 'pixiles
lastrow = pict.BottomRightCell.Row
lastcolumn = pict.BottomRightCell.Column
totalrows = lastrow - firstrow + 1
totalcolumns = lastcolumn - firstcolumn + 1


Next pict

End Sub
"MM User" wrote:

Hi,

This is a follow up from my previous mail, is it possible to check if a
picture is present on a particular cell i.e. check if graphic1 exist on Cell
A1 and also check its size?

Thanks!