VBA Create Sheet Arrays

[hobbiton73]

Hi, I wonder whether someone could help me please.

I'm using the code belwo to automatically create new worksheets within my Excel workbook and run a number of macros.

Please Login or Register  to view this content.

The problem I have is thast I'd like to create some more sheets and addb them to the first part of the code, but I'm receiving the error "Too many line continuations'.

The error is self explanatory, but I'm not sure how to overcome this.

I just wondered whether someone could possibly look at this please and offer some guidance on how I may overcome this.

Many thanks and kind regards

Chris

[romperstomper]

Put more than one sheet on a line:

Please Login or Register  to view this content.

[hobbiton73]

Hi @romperstomper, thank you so much for takng the time to come back to me with this, it is very much appreciated and it works great.

All the best and kind regards.

Chris

[romperstomper]

Glad to help. By the way, if you put a list of sheets in a named range somewhere, your code can simply read the values from there. That way if you need to add or remove sheets, the code remains the same - you just update the range.

[hobbiton73]

Hi @rompserstomper, thank you for the tip that's really useful.

Kin Regards and many thanks

Chris