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
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