pastespecial method of range class failed error

[drop05]

hello i am getting this run time error: pastespecial method of range class failed error

this is the area of my code that it is happening at

copy_wb.worksheets("Sheet1").range("f22:k22").copy
(error) -> paste_wb.worksheets("sheet1").range("d21:i21").offset(, myval).pastespecial paste:=xlPasteValue

not sure why this error is happening or how to fix it, any help would be great thank you!

 

[drop05]

wait i think i got it, correct if wrong, is it because i have pastevalue and not pastevalues?

 

[Fluff]

Does it work if you make that change?

 

[drop05]

Does it work if you make that change?

it does

 

[Fluff]

That answers your question then.