Posted to microsoft.public.excel.programming

SS[_3_]

external usenet poster

Posts: 14

Copying too much.

The following code should copy Columns C and D from one
workbook to another one. However, it is copying columns
A, B, C, and D.

Windows("Work Orders - Master.xls").Activate
Sheets("Drum Prep").Select
Columns("C:D").Select
Selection.Copy

Windows("Form.xls").Activate
Sheets("Drum Prep Comparison").Select
Columns("D:D").Select
ActiveSheet.Paste

Any ideas on how to fix this quirk?

Thanks

SS

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
copying row	nishkrish	Excel Discussion (Misc queries)	2	October 23rd 09 08:42 AM
copying a row	james b	Excel Worksheet Functions	6	June 17th 08 09:41 PM
copying the Hyperlink function result without copying the actual formula	mcheng	Excel Worksheet Functions	2	June 9th 07 02:43 AM
Copying data down to next dirty cell, then copying that data	slarson	Excel Programming	0	September 15th 03 09:19 PM
Help with copying please.	Don Guillett[_4_]	Excel Programming	0	July 12th 03 02:55 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us