maximum sheets in a book

N

neeraja

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

Thanks,
Neeraja.
 
J

J.E. McGimpsey

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.
 
J

jp

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
 
Top