worksheets.add - can I add and name a sheet at same time

[lezawang]

Hi
I know how to add a sheet using worksheets.add function but I wonder if I can name it as same time. The function syntax does not show any argument for name! Thanks you

Function Add([Before], [After], [Count], [Type]) As Object

 

[My Aswer Is This]

So you want to do this with a Function.
Not a vba script?

Is that correct?
I know how to write scripts but not so good writing functions

 

[lezawang]

Thanks for your reply. I want to write vba code and my code is this



Sub sheetadd()
Workbooks(1).Worksheets.Add before:=Workbooks(1).Worksheets(Worksheets.Count)
End Sub

My question can I at same time name it? I mean I thought I can pass to add function the name and finish with it. I tried to avoid doing another like

workbooks(1).worksheets(worksheets.count -1).name = "hello"

Thank you again.

 

[My Aswer Is This]

Here is how I do it:

Sub Add_Sheet()
'Modified  10/10/2018  8:44:37 PM  EDT
Sheets.Add(Before:=Sheets(1)).Name = "Susan"
End Sub

 

[lezawang]

great. Thank you so much.

 

[My Aswer Is This]

great. Thank you so much.

Glad I was able to help you.