same range name on multiple sheets

[mark]

It is possible to use the same range name on more than one
sheet. For instance, have cell A1 on sheet1 be
named "myRange", and have cell A1 on sheet2 also be
named "myRange" .

This type of thing can be done by copying a sheet that has
existing names on it.

For sheets which already exist, how can the name on one
sheet be defined to be the same thing as a name on another
sheet, without just changing the reference, instead of
creating a new one?

 

[Bernie Deitrick]

Mark,

You need to define them as sheet level names. For example, select A1 on
Sheet1, then in the name box, type

Sheet1!myRange

The display in the name box will change to show just myRange. Then switch
to sheet2, select A1, and type

Sheet2!myRange

in the name box.

HTH,
Bernie
MS Excel MVP

 

[mark]

Thank you, that is what I needed to know.

 

[Harlan Grove]

You need to define them as sheet level names. . . . ....

....

Not quite the same thing, but it's possible to define a workbook level name
that functions similarly. If foo!A2 contains 'foo' and bar!A2 contains
'bar', and FOOBAR were defined as =INDIRECT("A1"), then =FOOBAR in worksheet
foo would return 'foo' and in worksheet bar 'bar'.

 

[mark]

FOOBAR were defined as =INDIRECT("A1"), then =FOOBAR in
worksheet foo would return 'foo' and in worksheet
bar 'bar'.




Thanks, Harlan. Good to hear from you.

(and p.s., you were totally right about the inadequacies
of the object model in the 32 bit versions of Lotus)