Select ActiveCell from Image inside cell.

[spacebouncer]

Hi. I have Table1 in which I want to be able to select a row, and copy the row into a Table2 within another sheet. In one column of the row, I have an arrow image. I've attached a simple macro to the image so that when clicked, the next few columns of the row are copied and inserted into the top of the similar Table2 in another sheet. Essentially this allows me to very quickly select the rows I want from Table1 and copy into Table2. My macro starts with ActiveCell.Offset(, 1).ReSize(1, 7).Copy and works fine. I am able to copy the arrow into alls rows of the table, allowing me to select any row. The problem is I need to choose the ActiveCell which the arrow sits within manually. Is there some coding will allow the macro to recognise what cell the arrow sits within, and thus choose this as ActiveCell? Can't figure this one out myself, but perhaps this is some coding somewhere that associates the image with its location? This is a small issue, but the solution would allow me to create a very elegant program for myself and others to use in Excel and would be much appreciated. Thanks

 

[shg]

See the TopLeftCell property.

 

[spacebouncer]

See the TopLeftCell property.

So simple! Thanks a bunch, had no idea about this. I'd better get reading. Much appreciated.

 

[shg]

You're welcome.