Hi
Can anyone tell me how to add a new worksheet and rename it using VBA.
Thanks for the help.
Cheers!!
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks