range names across tabs

S

sunan

When a sheet of workbook A is copied into workbook B, range names of the
sheet are also copied, however workbook B doesn't seem to reqocnize those
imported names. How can I make workbook B recoqnizes them?
Thanks,
SUNAN
 
B

Barb Reinhardt

It's just a guess, but did you try to reference those names using something
like this?

=Sheet1!RangeName

or

=RangeName

I believe that when names are copied this way, they become worksheet level
names and you need to include the sheet name in the reference.
 
Top