Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set No of Sheets in new workbook
Hopefully a quickie for someone ;)
When using the VBA code: workbooks.add how do I determine the number of sheets in that newly created workboo (i.e rather than using the value set in excel's options on eac individual pc) -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set No of Sheets in new workbook
Application.SheetsInNewWorkbook = 5
Change the number to suit your purposes. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set No of Sheets in new workbook
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set No of Sheets in new workbook
Workbooks.Add
cSheets = ActiveWorkbook.Worksheets.Count -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "cornishbloke " wrote in message ... Hopefully a quickie for someone ;) When using the VBA code: workbooks.add how do I determine the number of sheets in that newly created workbook (i.e rather than using the value set in excel's options on each individual pc)? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
add new sheets in a workbook with new sheets being a variable | Excel Discussion (Misc queries) | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) |