Offset that change by it own.

[feejo]

I have that formula that I put into a NAME, then I use it into a graphic.
=DECALER('T&S Today'!$BK$21;1;0;NB('T&S Today'!BK34:$BK$2019);1)

I have excel in french
Declarer = offset
NB = CountA


Fist I have to adjust BK34 to BK 22
Then I delete my old data from the spead sheet.
Then I copy data into the spread sheet.
WOw it work.
Then I say "Let's save that work"
Bam! the graphic change, then BK22 into the NAME created become any weird reference, and the graphic change (cause the reference change)
Then I receive a message saying one formula contain a bad external reference.

Everytime I have to write down back BK22 for it to work.

[feejo]

ok I found it Yé

I just need to place $ on each side of BK

Thanks LORD.