Without seeing your actual workbook and being able to test, this is my best guess at this time. You have already defined wks as a worksheet, so you do not need to name it as part of the worksheets in the workbook. It is already a variable.


Application.ActiveWorkbook.wks.Index + 1.ActiveCell.Offset(-32, 0).PasteSpecial xlPasteValues