range names across tabs
 

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

range names across tabs
 

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.
--
HTH,
Barb Reinhardt



"sunan" wrote:

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