Hello Tom, The coding for the macro which you have written is good and I would like to draw your attention is that The first when the Macro is runned then there is no problem at all and it inserts the given input for inserting the sheets. If the macro is runned for the second time for inserting more sheets then it is giving a Run Time Error 104. On this error i would request you to do it yourself once and try to provide the solution.
Thanks in advance Regards Ahmed On Thu, Nov 13, 2008 at 3:50 AM, Tom Jeffries <[EMAIL PROTECTED]> wrote: > The attached worksheet contains a macro (AddSheets) that will create a > specified number of worksheets ass you describe. If you have any questions > let me know. > Tom > > On Tue, Nov 11, 2008 at 7:56 AM, Ajay Varshney < > [EMAIL PROTECTED]> wrote: > >> Hi, >> >> Is there any macro using which i could get number of sheets in a workbook >> equal to number of days in a month. >> >> For example : If i am preparing a report for October then I should get 31 >> sheets in the workbook and if i am preparing report for November then i >> should get 30 sheets in the workbook. >> >> Thanks >> >> >> > > > > -- Ahmed Bawazir --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
