Excel - run-time error PasteSpecial syntax 1

[srogers]

Hi-
Does anyone know the correct syntax for a line like this:

Workbooks("202forecast.xls&quot.Worksheets("Period 1&quot.Range("Period1Week1_202&quot.Copy _
Destination:=Workbooks("PeriodXXInProcess.xls&quot.Worksheets("WEEKONE&quot.Range("Week1_202&quot.PasteSpecial(Paste:=xlValues)

I get a 1004 run-time error:
"unable to get the PasteSpecial property of the Range class"

Or perhaps PasteSpecial is not allowed here. It worked before I added that on to the end.

I also tried it without the parenthesis around Paste:=xlValues
Thank you -

 

[TonyJollans]

Hi srogers,

You can't use pastespecial with copy destination; you must do it in two steps ..

.Range("Period1Week1_202&quot.Copy
.Range("Week1_202&quot.PasteSpecial Paste:=xlValues

Enjoy,
Tony