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