anchor within sheet

[doudou]

Hi,
I'd like, within a worksheet, to have anchors that are bringing me to specific cells in the sheet.
For example, when I create my anchor, liking to the cell A56, I'd like it to stay linked to the cell, even if I add (or substract) rows in my sheet.
Till now, I could make anchors linking to the A56 cell, but not following the value within the cell, when it moved to A148 because I had to add a lot of rows.
Anyone an idea ?
Thx
E

[starguy]

Hi,
I'd like, within a worksheet, to have anchors that are bringing me to specific cells in the sheet.
For example, when I create my anchor, liking to the cell A56, I'd like it to stay linked to the cell, even if I add (or substract) rows in my sheet.
Till now, I could make anchors linking to the A56 cell, but not following the value within the cell, when it moved to A148 because I had to add a lot of rows.
Anyone an idea ?
Thx
E

you should give a name to cell A56 then use that name to link it
select cell A56 and put a name (which ever you like) in the name box at the left most side of the formula bar (which is showing the selected cell name i-e A56).
you may put a name there like "anchor" (without quotes) then use this name while giving reference to cell A56
like
instead of =A56
use this =anchor

Regards

[doudou]

thx a lot, it's very simple and works perfect

[starguy]

thx a lot, it's very simple and works perfect

happy to help you.
thank you for the feedback.