how do I get the reference of the cell where a picture

[ecpl_3]

I want to be able to reference the cell where a picture or shape resides on
the excel spread sheet. I can get informatio for all pictures on the sheet
such as the ID, names,... but I would like to reference it based on cell
reference/location.

[Ron de Bruin]

Hi

You can use this

ActiveSheet.Shapes("mypicture").TopLeftCell.Select



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ecpl_3" <[email protected]> wrote in message news:[email protected]...
>I want to be able to reference the cell where a picture or shape resides on
> the excel spread sheet. I can get informatio for all pictures on the sheet
> such as the ID, names,... but I would like to reference it based on cell
> reference/location.

[ecpl_3]

Thanks Ron for your suggestion, it works great. Now for all the other
code........


"Ron de Bruin" wrote:

> Hi
>
> You can use this
>
> ActiveSheet.Shapes("mypicture").TopLeftCell.Select
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "ecpl_3" <[email protected]> wrote in message news:[email protected]...
> >I want to be able to reference the cell where a picture or shape resides on
> > the excel spread sheet. I can get informatio for all pictures on the sheet
> > such as the ID, names,... but I would like to reference it based on cell
> > reference/location.
>
>
>