LinkBack URL
About LinkBacks
an issue that has bothered me for years is when a sheet is moved from one workbook to another the listing of name ranges come along with it. I often speed hours cleaning up my name manager. Is it possible to pass a sheet or is a copy/paste required?
an issue that has bothered me for years is when a sheet is moved from one workbook to another the listing of name ranges come along with it. I often speed hours cleaning up my name manager. Is it possible to pass a sheet or is a copy/paste required?
Last edited by BobBlooms; 07-10-2012 at 09:57 AM. Reason: copied confuses the question
Hi Bob,
Welcome to the forum.
Please help me understand "pass a sheet" ... ?Is it possible to pass a sheet or is a copy/paste required?
I guess starting Excel 2007, the name manager window is more user friendly where you can get to see more detail(s) as compared to Excel 2003 and previous versions.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
a workbook has been cobled together from several workbooks which included various named ranges that do not apply to the new workbook. Often the named ranges come with a link outside the access ability of the current workbook's location forcing a broken link situation.
Okay.. so you can see such workbooks in Name manager window and then you can take necessary action(s).
Regards,
DILIPandey
<click on below 'star' if this helps>
yes, but my point is how do you move/copy a worksheet without the named ranges following on the coattails of the worksheet?
Named range will be moved / copied with the worksheet.. alternatively, you can do a ctrl + A , Ctrl + C on source worksheet and then Ctrl + V on the destination worksheet and this is what I do when I just need the data and formula from a sheet / workbook which has a lots of defined names
Regards,
DILIPandey
<click on below 'star' if this helps>
Or run this macro after copying
Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks