define a name in active cell only

[Hein]

Hi all,

Maybe a simple question
Searching the board and google don't give me the right answer

How can I define a range, only for the active cell?

Thanks in advance
Hein

[StephenR]

If you mean name a range:

Please Login or Register  to view this content.

Otherwise like this?

Please Login or Register  to view this content.

[Hein]

The line:

Please Login or Register  to view this content.

seems to do the trick

Thanks Stephen

[shg]

Or just

Please Login or Register  to view this content.

[StephenR]

Drat, I had a nagging feeling there was a simpler way. shg always finds it.

[shg]

People who type as slow as I do look for all sorts of ways to abbreviate everything, Stephen. I am doubly motivated as you frequently beat me in responding ...

[StephenR]

shg, I'm not sure about that, but even if it were true it merely brings to mind various sayings such as "more haste less speed", "look before you leap"...