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

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"JBW" wrote:

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