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

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


"JBW" wrote:

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