Hi Deepa, I had done several macros for creating pivots through a macro. Guess, I can help in this. To insert new worksheets, put "worksheets.add" in ur code, & worksheets.name =" xxx" to set the names
Sharad On 10/13/08, deepa bharti <[EMAIL PROTECTED]> wrote: > > Hi, > i know this would be a very basic question but I need to get create a pivot > through a macro but I am facing soem debugging issue . > can anyone help me with that. > Also I would like to know the command for inseting a new worksheet in an > workbook and renaming it. > > Thanks > > > > -- Sharad Sharma Mo: (+91) 98303 70814 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
