View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default Excel 2003-how copy tab w/o file refs?

before copying, replace = with x=
after copying, replace x= with =
"Ian Elliott" wrote in message
...
Thanks for any help.
I need to copy a tab back to a file I copied out of by mistake. When I

copy
back, there are the ='C:\Folder\[File name.xls\Tab name'!A1, and I am

using
global search and replace to remove, but there's alot, is there a way to

copy
with out the references?
Thanks.