runtime error 9

  • Thread starter Thread starter JBW
  • Start date Start date
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
 
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.
 
Back
Top