Naming a new worksheet

[ATLGator]

Hello,

If I wanted to add a new worksheet to a workbook and rename it, can I do something like this:

Please Login or Register  to view this content.

or does this require two steps, 1) create 2) then name?

If it's possible to achieve this task in one step, can someone correct the line of code I'm using? (note: Dim NewWS As Worksheet)

Thanks!

[jeffreybrown]

Try

Please Login or Register  to view this content.

[stnkynts]

Is this cheating? Still on one line

Please Login or Register  to view this content.

You can do it one line without the variable. Variable requires 2 steps as far as i know.

[ATLGator]

@jeffreybrown - perfect, and you pointed out some unnecessary code I was using
@stnkynts - yours did work too, but it seems I didn't need to set NewWS to the worksheet - this line was running through a loop

Thank you both!

[jeffreybrown]

You're welcome…glad you have a workable solution and thanks for the feedback...