Creating New work sheets and assigning names automatically
 

Is it ****ible 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

--
paz2
-----------------------------------------------------------------------
paz24's Profile: http://www.excelforum.com/member.php...fo&userid=3104
View this thread: http://www.excelforum.com/showthread.php?threadid=50718

Creating New work sheets and assigning names automatically
 

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" wrote in message
...

Is it ****ible 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