maximum sheets in a book

  • Thread starter Thread starter neeraja
  • Start date Start date
N

neeraja

Hi,
Could someone let me know What is the maximum number of
worksheets that can be inserted into a workbook???

Thanks,
Neeraja.
 
The number of worksheets is limited by your system resources (ie.,
RAM). You can only add (via VBA) 255 at a time, but you can keep
adding after that.
 
If you go to help and type LIMIT in the search field all will be revealed!

It would appear the memory is your only limit - but what about young
people?? Ha!

Cheers from North Yorkshire


John
 
Back
Top