Keep Shape's Reference to a cell when delete the cell

[liberovago]

Hi to all!

I have a shape that is linked with a cell in another sheet.
I need to eliminate the row that contains that cell, and recreate another row.
The fact is that the shape lose the reference with the error #REF. Is there a way to do not lose the reference (For example, the shape is linked with the cell A1 in sheet1. When I delete the row 1 that contains the cell A1, the shape becomes Sheet1!#REF!).

 

[Domenic]

First, define a name (Ribbon >> Formuls tab >> Defined Names group >> Define Name) referring to cell A1 in Sheet1. Change the name as desired.

Name:  MyDefinedName

Refers to:  =INDEX(Sheet1!$A:$A,1)

Click OK

Then, select your shape, and then link it to your cell using the defined name . . .

=MyDefinedName

Hope this helps!

 

[liberovago]

Thanks for the tip