Run-time error '9': Subscript out of range

Please help me to find why there is always the error of

Run-time error '9': Subscript out of range

For the macro below. It is proved to be working by Jerry Beaucaire, but just do not work in my case. The purpose of the macro is to combine multiple files into a single workbook.

Please Login or Register  to view this content.

Hi billj,

That error message usually means the code cannot find a specific tab that it's being referred to.

Though you haven't said what line is causing the error I'm guessing it's this one...

Please Login or Register  to view this content.

...which would mean you haven't created a tab called Master in the relevant workbook for the tabs to be imported into. If this is the case, name a tab Master in the desired workbook for the data to be imported into and try again.

Please also wrap you code with the appropriate tags as I have done.

Regards,

Robert

Hi Trebor76,

I named a tab in the desired workbook as Master. This removed the error. But nothing appeared in the desired workbook.

Have you changed the fPath variable to point to where your files are actually located?

Other than that I'm not sure as I haven't written the code. I'm sure Jerry would have tested it thoroughly so I'm sure it's just something minor like the location of the files as I've mentioned.

Robert