Gilly,

the limit is set by available memory on the machine you are using and unless
that is something very special you will almost certainly run out of memory
long before you have created 500 sheets.

Mike

"Gilly B" wrote:

Is there a maximum number of worksheets that can be in a single workbook - I
am considering setting up a system that will have 500+ individual sheets -
albeit with very basic information/formulas on each one. Is this OK?