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

Hi Pat,

Look he

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

or

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pat" wrote in message ...
| 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
|
|

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


"Niek Otten" wrote in message
...
Hi Pat,

Look he

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

or

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pat" wrote in message
...
| 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
|
|

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




"Pat" wrote in message
...
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


"Niek Otten" wrote in message
...
Hi Pat,

Look he

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

or

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pat" wrote in message
...
| 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
|
|