Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking for a picture
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connect a number to a picture bank and import that picture to exce | Excel Discussion (Misc queries) | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
Checking range of cells for entry then checking for total | Excel Programming |