View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JeanPierre Charron JeanPierre Charron is offline
external usenet poster
 
Posts: 24
Default Copy / Append values of a named range from Workbook A Sheet1 to aclosed Workbook B Sheet1 in same folder

My range named X, only contains formulas
I need to copy / append values of this range to a closed destination workbook
in the same folder, which has the same number of columns and format as my named range.
Then, Save and Close the destination Workbook
and display message "Task Completed".
Thank you for your help.
J.P.