Seems like if we open a workbooks from a path, close it, open it again, and use code workbooks(wb_variable).activate is giving a script out of range error.
How do we resolve this ?
Seems like if we open a workbooks from a path, close it, open it again, and use code workbooks(wb_variable).activate is giving a script out of range error.
How do we resolve this ?
wb_variable cannot be > than the # workbooks.
What does wb_variable equal? did it change?