Runtime Error '9' Subscript out of Range

[Ryannn]

Hi all,

I have ben creating a macro for a client and when i fun it i get the error listed in the title of this thread.
When i go to debug it the highlighted part is
Windows("AZ Passengers on a Plane 15-01-2013.xls").Activate

Does anyone have any ideas in how to resolve this issue.

it would be most appriciated.
Many thanks

 

[Andrew Poulsom]

Welcome to MrExcel.

Check that that workbook is open. If it is make sure that the name matches exactly.

 

[Ryannn]

I have looked through the code and i have noticed there is a difference in the names.
I have changed it and it now works.

Thank you very much for the reply.