How many sheets can i insert in excel 2003 ???
N Nick Hodge Dec 14, 2005 #2 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 [email protected]
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 [email protected]
