LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default copying named cells into new workbook

Is it possible to copy and paste named cells from one workbook to another
without having the origin file name pasting in as well? So if i'm pasting a
cell named XYZfrom One.xls into Two.xls will Two.xls have a cell called
One.xls!XYZ ? It is important that the Two.xls workbook have absolutely no
reference to One.xls. Also, how do I keep the message that asks if I want to
keep the cell name from popping up when I'm pasting into Two.xls?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying cells from one workbook to another Quinci Excel Worksheet Functions 0 January 25th 08 05:57 PM
Copying worksheets with hyperlinks to named cells Teri Miller New Users to Excel 1 June 6th 07 04:46 PM
Copying named lists used in drop downs from one workbook to anothe Kevin L. Excel Worksheet Functions 0 November 9th 06 10:02 PM
Need Help Copying cells into another workbook Andrew[_47_] Excel Programming 1 September 17th 04 12:47 PM
Copying a named range of cells Darrel[_3_] Excel Programming 1 October 29th 03 04:59 PM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"