Insert Name

[Patrik Karlstrom]

Hi and thanks in advance.

How do I insert a name using Insert Name Define? I don't want to add the
actual sheet reference if I need to move it to another location in the same
worksheet. I want to avoid having to change the reference if I move the
name. For now it's for printing purposes (Page Setup-Sheet-Print Areas
(Where I type in the name)-Print), but I will add more functions to it
later. Was this clear? I won't be here for any more info until much later.

Any input will be much appreciated

 

[JulieD]

Hi Patrik

unsure of how you are going to "move the name"
once you have defined a range name the only way (AFAIK) to redefine it is to
go into Insert / Name / Define and change the refers to values - so in this
case it doens't matter what is shown in the refers to bit as you're going to
change it anyway - or am i missing something?

Cheers
JulieD