Creating New work sheets and assigning names automatically

[paz24]

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

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

thank

 

[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)