runtime error (9)

J

JBW

I have a macro tht runs perfectly on three different machines, but whenever
we try to run it on fourth (all machines have same version of excel) it fails
and comes up with runtime error (9) subscript out of range, when you hit
debug it takes you to line in VBA (highlighted in yellow) that says
windows(macrofile).activate

can find no software version difference between machines, and all running
same operating system.

any ideas

James
 
J

John Bundy

The system is not finding whatever you are calling macrofile, is that a
string you use for a path or sheetname? or is it just the name of the window?
either way what you are trying to call is not there.
 

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 9 error 2
Runtime Error '9' - Subscript Out of Range 7
Debuging Macros 1
Load a File Error 9 7
Application.Calculate - Runtime Error 1
Runtime error 9 5
Runtime error 424 in Windows 8 environment 15

Top