Subscript Out Of Range Error

[MikeG]

I have a workbook called "Project" and in it there is a macro that pulls data out of another workbook called "Operations Report."

The macro works fine on my laptop. When I run the macro, I make sure that both workbooks are open, (and they are also saved in the same directory - not sure that matters).

I sent the two workbooks to a colleague and when she opens them both and runs the macro, she gets a "run error 9 subscript out of range" error. She too has saved them to the same directory.

Can anyone suggest why she might be getting the error when I do not? Here is the line where hers trips up:

With Workbooks("Operations Report").Worksheets("Sheet2")

I assume that the macro is not finding the "Operations Report" workbook.

Are there some checks we could do or test lines of code I could send to her to diagnise the problem?

Thanks,

MikeG

 

[MikeG]

Maybe try referencing the sheet differently?

With Workbooks("Operations Report.xls").Sheets("Sheet2")

Thanks John.

Same issue - works OK on my laptop but not for my coworker.

Mike

 

[GTO]

I would suggest showing us the calling code, which I think is in the Project wb?