runtime error 9

J

JBW

I have a macro that runs perfectly on three machines but not the 4th, it
comes up with runtime error (9) subscript out of range, when I hit debug it
highlights windows(macrofile).activate line in vba code.

All machines run same operating software and have same version of excel.

any ideas
 
J

John Bundy

I replied to this a while back but don't see it so here it is again. Whatever
macrofile is cannot be found, whether it is a path or variable or whatever.
It is searching for a window with that name, there isn't one, check to see
what it is looking for, and whether or not you have it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

runtime error (9) 1
Runtime error 424 in Windows 8 environment 15
Macro warning in word 1
runtime 9 error 2
Runtime Error '9': Subscript Out Of Range 6
Load a File Error 9 7
Run-time error '9' 6
subscript out of range 2

Top