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.
 

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

Need Help with Macro Security 1
Change a great number of words in word files, with a macro as short as possible. 5
Incorporating the User Profile location into a document template path 1
Copy addition formula of non-consecutive horizontal cells 2
VBA for Dependents shortcut menu 0
Finding the right style field in VBA 0
Automation of scanned file storage based on content 0
How to copy cells by collor code 0

Top