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 > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
AddSheets.xls
Description: MS-Excel spreadsheet
