View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default problem with copy to another workbook

Hi tanyhart,

Just a quick stab in the dark...

What if you change...

destrange.PasteSpecial xlPasteValues, , False, False

to...

destrange.PasteSpecial xlPasteFormulas, , False, False

Ken Johnson