name of cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mino - 18 Mar 2008 16:01 GMT

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.

Reply to this Message

Jim Thomlinson - 18 Mar 2008 16:40 GMT

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.

Signature

HTH...

Jim Thomlinson

> Hi to all.
> I need to have a static name of cell.
[quoted text clipped - 5 lines]
> thanks in advance
> M.

Reply to this Message

Tom Hutchins - 18 Mar 2008 16:56 GMT

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

> Hi to all.
> I need to have a static name of cell.
[quoted text clipped - 5 lines]
> thanks in advance
> M.

Reply to this Message