LinkBack URL
About LinkBacks
I have a macro in one workbook that jumps between this workbook and another workbook, but today I get an error on the line that activates the other workbook. Error:9 Subscript out of range. No changes made, it always worked before
I have a macro in one workbook that jumps between this workbook and another workbook, but today I get an error on the line that activates the other workbook. Error:9 Subscript out of range. No changes made, it always worked before
Last edited by frank35; 11-29-2013 at 02:06 PM.
Post your code.
Gary's Student
sorry, top secret. Can only say that absolutely nothing changed and now it doesnt work any more
this makes absolutely no sense. So disappointing.
How can a single line of code be top secret?
Maybe your computer lacks the clearance necessary to run it ...
Entia non sunt multiplicanda sine necessitate
--> Subscript out of range
Please Login or Register to view this content.
Last edited by frank35; 11-29-2013 at 02:04 PM.
So what is wrong here? The name is exactly the same and it worked before. Is there a way around this or another way to switch workbooks ? It worked before!!!
Hi, frank35,
even a one-liner should be wrapped with code-tags.
So you file is just called Some Workbook, no extension?
assuming a macrofree workbook should work but IŽd set objects to the workbook to avoid switching between them (and getting RTE).Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hallo Holger!
Thank you so much for you Hilfe!
It works now!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks