I have a line generating an error "Subscript Out of Range"
I've run the macro before successfully, but am now trying to run the code on a new machine with a newer version of excel (2019). I have the file open, but receive an error. The workbook "annualof.xls" is "protected" and is of the type Microsoft Excel 97-2003 Worksheet.
Is either the protected status or the worksheet/book type causing the code to be inaccurate?
Ideas?
Code:
Windows("annualof.xls").Activate
I've run the macro before successfully, but am now trying to run the code on a new machine with a newer version of excel (2019). I have the file open, but receive an error. The workbook "annualof.xls" is "protected" and is of the type Microsoft Excel 97-2003 Worksheet.
Is either the protected status or the worksheet/book type causing the code to be inaccurate?
Ideas?