Thread: Copy worksheet from one workbook to another workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_434_] joel[_434_] is offline
external usenet poster
  
Posts: 1
Default Copy worksheet from one workbook to another workbook

I left out cells

from

'paste values
NewSht.PasteSpecial _
Paste:=xlPasteValues

'paste formats
NewSht.PasteSpecial _
Paste:=xlPasteFormats


to

'paste values
NewSht.cells.PasteSpecial _
Paste:=xlPasteValues

'paste formats
NewSht.cells.PasteSpecial _
Paste:=xlPasteFormats


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165571

Microsoft Office Help

Reply With QuoteReply With Quote