Home |
Search |
Today's Posts |
#1
|
|||
|
|||
creating mutiple worksheets
How do I create multiple worksheets (as in 100+) with minimal keystrokes?
|
#2
|
|||
|
|||
malvis, you could use a macro like this,
Sub Add_Sheets() Worksheets.Add Count:=100 End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "malvis" wrote in message ... How do I create multiple worksheets (as in 100+) with minimal keystrokes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Worksheets | Excel Discussion (Misc queries) | |||
Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
Creating a graphic from worksheet's data: like a "progress" thermo | Charts and Charting in Excel | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Combine Mutiple Worksheets into one | Excel Discussion (Misc queries) |