How many sheets can i insert???
 

How many sheets can i insert in excel 2003 ???
--
eml

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

How many sheets can i insert???
 

Thanks a lot Nick...

Have a nice day...

--
eml


"Nick Hodge" wrote:

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