How do you select images progammically

[Pat]

Is there a way to select images progammically on an excel sheet. I have a
sheet with several hundred images, each referenced to a given cell in col D.
When I run a filter based on a value in col C I would then like to select
the filtered images progammically, rather than go through each one and
select manually. Ant way this can be done?

Pat

 

[Niek Otten]

Hi Pat,

Look here:

http://www.jkp-ads.com/articles/showpicture00.htm

or

http://www.mcgimpsey.com/excel/lookuppics.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is there a way to select images progammically on an excel sheet. I have a
| sheet with several hundred images, each referenced to a given cell in col D.
| When I run a filter based on a value in col C I would then like to select
| the filtered images progammically, rather than go through each one and
| select manually. Ant way this can be done?
|
| Pat
|
|

 

[Pat]

Thank you Niek for your assistance, unfortunately I only want to find a way
to select all of the filtered images at once and then delete them. I could
hold down the ctrl key and select each one, but that will take me quite a
while.

Pat

 

[Pat]

If I try:
ActiveSheet.DrawingObjects.Delete
this will delete all images on the sheet both filtered and unfiltered
images.