In Excel, I want to check if a specific cell for instance "C12" has a picture?
How could I do this?
views:
35answers:
1
+4
A:
You do this by looping through Shapes collection of the worksheet, looking for a shape whose .TopLeftCell has same address as your target range.
GSerg
2010-02-23 19:01:07
Is it possible to check whether that shape is picture or icon? because there are various types of shapes
Kevin Boyd
2010-02-23 19:07:55
Also is there a more direct way of doing this, using a Cell and checking it for a picture.
Kevin Boyd
2010-02-23 19:13:46
`.Type` property gives you the type. Please press F2 in the IDE and examine the object model. I never new answer to this question but it took me 10 seconds to look it up in the Object Browser.
GSerg
2010-02-23 20:26:27