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 here:

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

or

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pat" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> "Pat" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> | 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>> "Pat" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> | 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
>> |
>> |
>>
>>
>
>