LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default problem copy/pasting pages.

Can someone give me code to copy a worksheet from one workbook to a new
workbook? I need to copy 2 sheets. When I try to copy one
(Application..Worksheets("Data1").Copy) it seems to automatically
create a new workbook called "Book1". When I try to copy the second
sheet it creates another workbook. I need to paste the second sheet
into book1 also.

Thanks,
rut

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting PDF pages into Worksheets Jim Johnson Excel Discussion (Misc queries) 1 November 10th 06 08:50 PM
Copy and Pasting JZ Excel Discussion (Misc queries) 1 July 25th 06 04:31 AM
Copying and Pasting from Web Pages Christina Excel Discussion (Misc queries) 0 March 29th 06 07:56 PM
Copy and Pasting Every Third Row teo2099 Excel Worksheet Functions 0 August 25th 05 07:02 PM
Copy pasting problem neil Excel Discussion (Misc queries) 3 July 13th 05 01:40 PM


All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"