| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Sheets
I am able to add sheets to a workbook. However I would like the code to add
the new sheet after the selected sheet. What is the syntax? Sheets.Add????? Thanks!! DB |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Sheets
activeworkbook.Worksheets.Add After:=Activesheet
-- Regards, Tom Ogilvy "DB" wrote in message ... I am able to add sheets to a workbook. However I would like the code to add the new sheet after the selected sheet. What is the syntax? Sheets.Add????? Thanks!! DB |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Sheets
Tom, in this same line of code can I indicate the sheet name as well?
Thanks! DB "Tom Ogilvy" wrote: activeworkbook.Worksheets.Add After:=Activesheet -- Regards, Tom Ogilvy "DB" wrote in message ... I am able to add sheets to a workbook. However I would like the code to add the new sheet after the selected sheet. What is the syntax? Sheets.Add????? Thanks!! DB |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Sheets
activeworkbook.Worksheets.Add(After:=Activesheet). Name = "NewSheet"
-- Regards, Tom Ogilvy "DB" wrote in message ... Tom, in this same line of code can I indicate the sheet name as well? Thanks! DB "Tom Ogilvy" wrote: activeworkbook.Worksheets.Add After:=Activesheet -- Regards, Tom Ogilvy "DB" wrote in message ... I am able to add sheets to a workbook. However I would like the code to add the new sheet after the selected sheet. What is the syntax? Sheets.Add????? Thanks!! DB |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Sheets
Thank you so much for your help!!
DB "Tom Ogilvy" wrote: activeworkbook.Worksheets.Add(After:=Activesheet). Name = "NewSheet" -- Regards, Tom Ogilvy "DB" wrote in message ... Tom, in this same line of code can I indicate the sheet name as well? Thanks! DB "Tom Ogilvy" wrote: activeworkbook.Worksheets.Add After:=Activesheet -- Regards, Tom Ogilvy "DB" wrote in message ... I am able to add sheets to a workbook. However I would like the code to add the new sheet after the selected sheet. What is the syntax? Sheets.Add????? Thanks!! DB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming | |||
Linear Mode
