limit on number of worksheets

[Maggie]

I was wondering if there was a limit on the number of worksheets that
are inserted in through a macro. I can only get 35 worksheets and I
need to get 50-60 worksheets. Once I try to enter the 36 worksheet
and error 400 comes up. any suggestions to fix this would be greatly
appreciated.

Maggie

 

[Jean-Yves]

Hi,
From XL help (XL XP) Sheets in a workbook Limited by available memory
(default is 3 sheets)

Regards
JY

 

[Jean-Yves]

Do you copy sheets to add, or insert NEW one.

There is a bug when you copy sheets
instead insert, new sheet, then copy info
JY

 

[Bob Phillips]

36 should be easy. Can you show the code, it is probably something in there.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Maggie]

Do you copy sheets to add, or insert NEW one.

There is a bug when you copy sheets
instead insert, new sheet, then copy info






- Show quoted text -

So if I wanted to insert new sheets before copying how would I do that
as a macro? Because I got a debug message a min. ago.
Maggie

 

[Maggie]

So if I wanted to insert new sheets before copying how would I do that
as a macro? Because I got a debug message a min. ago.
Maggie- Hide quoted text -

- Show quoted text -

Here is my macro:
Sub Button197_Click()
'
' Button197_Click Macro
' Macro recorded 02/28/2007 by fhlbmes
'

'
Sheets("HOEPA Worksheet").Copy Before:=Sheets(1)
Sheets(1).Name = Application.InputBox("Enter Loan Number", Number)
Sheets(1).Range("g13").Value = Sheets(1).Name
End Sub

 

[Bob Phillips]

What error? Where? worked fine for me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Maggie]

What error? Where? worked fine for me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)








- Show quoted text -

Oh so you were able to copy 50 sheets on that tab?