Posted to microsoft.public.excel.programming

external usenet poster

Posts: 202

Copy Multiple Sheets, Except Q

How could I tweak the code below that will copy all sheets from my
ActiveWorkbook EXCEPT for sheets A;B and C?

Code below will copy 2 specified sheets, but I want to twist this
around as I have a large number to copy and don't want to hard code
them as below

Set Sourcewb = ActiveWorkbook
Sourcewb.Sheets(Array("Header", "Order")).Copy
Set Destwb = ActiveWorkbook

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
copy rows to multiple sheets	pvkutty	Excel Discussion (Misc queries)	1	February 24th 10 07:25 AM
Copy multiple sheets using a list box	kev_06[_3_]	Excel Programming	1	June 2nd 06 11:10 PM
Copy & Past from multiple sheets to one	Prometheus[_12_]	Excel Programming	18	December 5th 05 12:36 AM
Multiple sheets selection and copy	syaronc[_6_]	Excel Programming	1	October 25th 04 12:40 PM
Copy from Multiple Sheets	Eric[_23_]	Excel Programming	3	August 5th 04 07:00 PM

All times are GMT +1. The time now is 01:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us