PasteSpecial

paulyf · May 3rd, 2002, 02:57 AM

Hi all,

I want to copy from one workbook and paste special "column widths" and "values" into another workbook. My crude code currently reads:

Range("A8:M48").Select
Selection.Copy
Windows("Book1").Activate
Sheets("Sheet3").Select
ActiveSheet.PasteSpecial_
Paste:=xlColumnWidths
ActiveSheet.PasteSpecial Paste:=xlValues

Anybody tell me where I'm going wrong?

As always, patience and help much appreciated!

Cheers - Paul

Ivan F Moala · May 3rd, 2002, 03:17 AM

Select the cell to paste to 1st
eg [A1].pastespecial paste:=8

NB: Don't USE paste:=xlcolumnwidths

Use the Constant 8 or Define the xlwidths
as;

Const Xlcolumnwidths = 8

paulyf · May 3rd, 2002, 03:24 AM

Thanks a lot Ivan.

What's the constant for paste special "values"?

Cheers - Paul

paulyf · May 3rd, 2002, 03:34 AM

paulyf · May 3rd, 2002, 03:34 AM

Being stupid - constant just follows tab order in Paste Special box!!

Problem resolved - Many Thanks

May 3rd, 2002, 03:17 AM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Select the cell to paste to 1st eg [A1].pastespecial paste:=8 NB: Don't USE paste:=xlcolumnwidths Use the Constant 8 or Define the xlwidths as; Const Xlcolumnwidths = 8 __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 02:57 AM	#1
paulyf New Member Join Date: Mar 2002 Location: Paul Posts: 34	Hi all, I want to copy from one workbook and paste special "column widths" and "values" into another workbook. My crude code currently reads: Range("A8:M48").Select Selection.Copy Windows("Book1").Activate Sheets("Sheet3").Select ActiveSheet.PasteSpecial_ Paste:=xlColumnWidths ActiveSheet.PasteSpecial Paste:=xlValues Anybody tell me where I'm going wrong? As always, patience and help much appreciated! Cheers - Paul

May 3rd, 2002, 03:24 AM	#3
paulyf New Member Join Date: Mar 2002 Location: Paul Posts: 34	Thanks a lot Ivan. What's the constant for paste special "values"? Cheers - Paul

May 3rd, 2002, 03:34 AM	#4
paulyf New Member Join Date: Mar 2002 Location: Paul Posts: 34