View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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