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