View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GJR3599 GJR3599 is offline
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?