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
|