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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do I get the reference of the cell where a picture (https://www.excelbanter.com/excel-programming/345831-how-do-i-get-reference-cell-where-picture.html)

ecpl_3[_2_]

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

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

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

Hi

You can use this

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

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

"ecpl_3" wrote in message ...
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[_2_]

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

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

All times are GMT +1. The time now is 07:26 PM.