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

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

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

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

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