Help with subscript error
 

I have 6 worksheets with VBA code to create a months worth of worksheets
using 4 templates. I made some changes to the code and now I get runtime
error 9 subscript out of range. Each worksheets templates are different
slightly. It works on all but two. Any help is appreciated.
Can send code but it needs the templates to work.

Help with subscript error
 

Paolo, check for your sheet names. Would you be able to post your code so
that someone can look into?

If this post helps click Yes
---------------
Jacob Skaria


"Paolo" wrote:

I have 6 worksheets with VBA code to create a months worth of worksheets
using 4 templates. I made some changes to the code and now I get runtime
error 9 subscript out of range. Each worksheets templates are different
slightly. It works on all but two. Any help is appreciated.
Can send code but it needs the templates to work.

Help with subscript error
 

I found it! It was very simple mistake!

"Paolo" wrote:

I have 6 worksheets with VBA code to create a months worth of worksheets
using 4 templates. I made some changes to the code and now I get runtime
error 9 subscript out of range. Each worksheets templates are different
slightly. It works on all but two. Any help is appreciated.
Can send code but it needs the templates to work.

Help with subscript error
 

The archives would like to know what it was

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Paolo" wrote in message
...
I found it! It was very simple mistake!

"Paolo" wrote:

I have 6 worksheets with VBA code to create a months worth of worksheets
using 4 templates. I made some changes to the code and now I get runtime
error 9 subscript out of range. Each worksheets templates are different
slightly. It works on all but two. Any help is appreciated.
Can send code but it needs the templates to work.