runtime error 9

[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

 

[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.