Hi-
Does anyone know the correct syntax for a line like this:
Workbooks("202forecast.xls"
.Worksheets("Period 1"
.Range("Period1Week1_202"
.Copy _
Destination:=Workbooks("PeriodXXInProcess.xls"
.Worksheets("WEEKONE"
.Range("Week1_202"
.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 -
Does anyone know the correct syntax for a line like this:
Workbooks("202forecast.xls"
Destination:=Workbooks("PeriodXXInProcess.xls"
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 -