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!! -- 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 |
Add New Worksheet Using VBA
Worksheets.Add.Name = "mysheet"
-- HTH RP (remove nothere from the email address if mailing direct) "Hani Muhtadi" wrote in message news:Hani.Muhtadi.1x40mb_1129658709.0692@excelforu m-nospam.com... 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 |
Add New Worksheet Using VBA
try doing it while recording a macro
-- Don Guillett SalesAid Software "Hani Muhtadi" wrote in message news:Hani.Muhtadi.1x40mb_1129658709.0692@excelforu m-nospam.com... 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 |
All times are GMT +1. The time now is 11:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com