name of cell

[mino]

Hi to all.
I need to have a static name of cell.
I mean: if I name cellA3 "dday", after a sort, this cell has new addres (ex
A5), but the name "dday" remains to address A3.

Is there a way to mantein same name? No vba.

thanks in advance
M.

 

[Jim Thomlinson]

To the best of my knowledge there is no way to make a named reange move as
the result of a sort.
For future reference if you do not want a VBA solutions Excel Programming is
probably not the best forum to post in.

 

[Tom Hutchins]

Name A3 dday using the Name Box. From the Insert menu, select Name >> Define.
Click on dday and check the Refers To box. Make sure the row & column have
dollar signs before them ($A$3, not just A3). This will keep dday set to A3
even after sorting the data.

Hope this helps,

Hutch