View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default How many sheets can i insert???

It's limited by available memory.

I just added 1000 with no probs

Sub Test()
Dim x As Integer
For x = 1 To 1000
Worksheets.Add
Next x
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"e_mlm_m" wrote in message
...
How many sheets can i insert in excel 2003 ???
--
eml