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" wrote in message
ups.com...
On Mar 5, 11:10 am, "Maggie" wrote:
On Mar 5, 10:47 am, "Jean-Yves" wrote:





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"Maggie" wrote in message

oups.com...

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- Hide quoted text -

- 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- 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 Befo=Sheets(1)
Sheets(1).Name = Application.InputBox("Enter Loan Number", Number)
Sheets(1).Range("g13").Value = Sheets(1).Name
End Sub