Thread: How can I get excel to accept larger workbooks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default How can I get excel to accept larger workbooks
There is no limit on worksheets in a workbook The only limit is available
memory...

If you run this code it will happily create 300 worksheets

Sub test()
Dim lng As Long
For lng = 1 To 300
ThisWorkbook.Worksheets.Add
Next lng
End Sub

To find out about memory limits check out this link...
http://www.decisionmodels.com/memlimits.htm

--
HTH...

Jim Thomlinson


"Frustrated" wrote:

I am currently using Quatro-Pro to create workbooks. It will accept at least
500 worksheets per workbook. Since Excel is set to 256 worksheets per
workbook, I can't transfer my current work to Excel. How can I increase the
size of Excel workbooks?
Reply With QuoteReply With Quote