Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Joel worked a treat!! Thanks
-- Regards David "joel" wrote: 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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy worksheet from one workbook to a master workbook | Excel Worksheet Functions | |||
How to Copy entire Worksheet from Workbook S to Workbook D | Excel Programming | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
How do I copy a worksheet form a workbook in my workbook | Excel Programming | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |