Add New Worksheet Using VBA

Hi

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

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]...
>
> Hi
>
> Can anyone tell me how to add a new worksheet and rename it using VBA.
> Thanks for the help.
> Cheers!!
>
>
> --
> Hani Muhtadi
> ------------------------------------------------------------------------
> Hani Muhtadi's Profile:
http://www.excelforum.com/member.php...o&userid=26794
> View this thread: http://www.excelforum.com/showthread...hreadid=477226
>

try doing it while recording a macro

--
Don Guillett
SalesAid Software
[email protected]
"Hani Muhtadi" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi
>
> Can anyone tell me how to add a new worksheet and rename it using VBA.
> Thanks for the help.
> Cheers!!
>
>
> --
> Hani Muhtadi
> ------------------------------------------------------------------------
> Hani Muhtadi's Profile:
http://www.excelforum.com/member.php...o&userid=26794
> View this thread: http://www.excelforum.com/showthread...hreadid=477226
>