Add New Worksheet Using VBA

[Hani Muhtadi]

Hi

Can anyone tell me how to add a new worksheet and rename it using VBA.
Thanks for the help.
Cheers!!

 

[Bob Phillips]

Worksheets.Add.Name = "mysheet"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hani Muhtadi" <[email protected]>
wrote in message
news:[email protected]...

 

[Don Guillett]

try doing it while recording a macro

--
Don Guillett
SalesAid Software
[email protected]
"Hani Muhtadi" <[email protected]>
wrote in message
news:[email protected]...