Runtime Error 9

[MikeDBMan]

I changed the activewindow.caption and in code in another vba project. Now I have saved the name of the current spreadsheet and activate another spreadsheet. Then when I try to go back to my original spreadsheet, I get the error, "Runtime Error 9 Subscript out of range". But the name of the workbook is exactly the same as the name I am trying to activate. Could the caption change have something to do with my error? Thanks. If so, what do I do?

 

[Andrew Poulsom]

Are you using Workbooks or Windows to activate the workbook? The former should work regardless of the window caption.

 

[MikeDBMan]

I was using
Windows(MyWB).activate

So when I changed to
Workbooks(MyWB).activate

It worked great! Thanks for the tip!