Creating New work sheets and assigning names automatically

[paz24]

Is it pissible with VBA excel to create a new worksheet and assign to it a name automatically?

Basically I have a button which runs a piece of VBA code which includes creating a new worksheet. Ideally when i click on that button Excel would know thaht the worksheet to be created should have a particular name such as "ABC" instead of "sheet1", "sheet2" etc

thanks

[Bob Phillips]

worksheets.add.name = "ABC"

but how does it know it should be ABC?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"paz24" <[email protected]> wrote in message
news:[email protected]...
>
> Is it pissible with VBA excel to create a new worksheet and assign to it
> a name automatically?
>
> Basically I have a button which runs a piece of VBA code which includes
> creating a new worksheet. Ideally when i click on that button Excel
> would know thaht the worksheet to be created should have a particular
> name such as "ABC" instead of "sheet1", "sheet2" etc
>
> thanks
>
>
> --
> paz24
> ------------------------------------------------------------------------
> paz24's Profile:
http://www.excelforum.com/member.php...o&userid=31046
> View this thread: http://www.excelforum.com/showthread...hreadid=507188
>