| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Names on Tabs Disappearing | Excel Discussion (Misc queries) | |||
| Tabs with different names | Excel Worksheet Functions | |||
| Reading tabs names | Excel Discussion (Misc queries) | |||
| add in that shows names of tabs in workbook | Excel Worksheet Functions | |||
| Worksheet Tabs Names as Dates | Excel Worksheet Functions | |||
Linear Mode
