range names across tabs

  • Thread starter Thread starter sunan
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to copy value in field and insert it into filter 2
Copying a named range with a changing cell reference 1
How can I migrate MBOX to PST? 2
Driving Me MAD !!!!! 1
Naming ranges on multiple worksheets 3
Consistent Sheet column header rows 2
AutoFilter Criteria using named range 4

Back
Top