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