Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on number of worksheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on number of worksheets
Hi,
From XL help (XL XP) Sheets in a workbook Limited by available memory (default is 3 sheets) Regards JY "Maggie" wrote in message ups.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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on number of worksheets
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 ups.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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on number of worksheets
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" wrote in message ups.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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on number of worksheets
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 ups.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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on number of worksheets
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on number of worksheets
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit on number of worksheets
On Mar 5, 5:37 pm, "Bob Phillips" wrote:
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- Hide quoted text - - Show quoted text - Oh so you were able to copy 50 sheets on that tab? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exceeded number of worksheets limit | Excel Discussion (Misc queries) | |||
copying worksheets in a workbook limit? | Excel Worksheet Functions | |||
Limit on # of worksheets in a workbook | Excel Discussion (Misc queries) | |||
Is there a limit to the number of worksheets in an excel file? | Excel Discussion (Misc queries) | |||
Limit Printing of Worksheets. | Excel Programming |