rename worksheet in vba

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!