MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Create Sheet


Posted by Ben on April 05, 2001 1:27 PM

How do I create a worksheet in Excel using a macro, that doesn't create a sheet and then rename it, but creates the sheet with a desired name.

Thanks
Ben


Posted by Barrie Davidson on April 05, 2001 1:30 PM

This should do the trick for you.
Sheets.Add
ActiveSheet.Name = "WHATEVER NAME YOU WANT"

Posted by Ben on April 05, 2001 1:44 PM

Thanks

Thanks
Ben