Macro for create no. of sheets.

Microsoft Excel 010 - complete package
June 15, 2011 at 10:01:58
Specs: Windows 7, Pentium (R) Dual core/3GB
Macro for create no. of sheets which will be taken from active sheet, cell - A1 to A9/10/etc(Until the cell is empty). I can create macro for create a sheet. but i am not able to create many sheets as i expect.

Workbook has 2 sheets named, 'Sheet1' and 'Sheet2'.
Sheet2 is a template for all the sheets to be created.
In Sheet1, I may enter values (Sheet names to be created) for any no. of cells. If i enter a1 to a10 then ten sheets should be created, if i enter 20 then twenty sheets need to be created.

Pls help me on the same.


See More: Macro for create no. of sheets.

Report •


#1
June 15, 2011 at 10:59:27
re: I can create macro for create a sheet. but i am not able to create many sheets as i expect.

Show us what you've done so far...maybe it only needs a little modification.

Click on the last line of this post before posting your VBA code.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question