MrExcel Publishing
Your One Stop for Excel Tips & Solutions

rename worksheet in vba

Posted by Latisha on June 14, 2001 1:11 PM

I would like to rename a worksheet in Excel through VBA. My macro adds a new sheet to the workbook, and I would like to assign a new name to it. I can get the sheetname using ActiveSheet.Name, but I haven't been able to rename the sheet in the macro. Anyone figured this out already? Thanks!

Posted by Barrie Davidson on June 14, 2001 1:18 PM

Try Activesheet.Name = "Whatever you want"