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.

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.
--
HTH...

Jim Thomlinson


"mino" wrote:

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.

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

"mino" wrote:

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.