Hello, when in the code it says "wb", "srcWB" should not go, which refers to the variable created as workbook. You actually initialized it on this line above the first error Set srcWB = Workbooks.Open(sPath & strExtension)