Generic macro to re-name the tab

[crt123]

I want to create a macro to re-name the sheet/tab to a standard name, regardless of the current name of the tab. When using 'record macro', it requires that the current tab name be stated:
Sheets("Current Name").Name = "NewName". Is there a way to make the command generic, like Sheets(Current Sheet).Name = "NewName" so that it will work in all cases? I will only use this on one-tab workbooks. Thanks

[hafizimran]

Please Login or Register  to view this content.

[crt123]

Thanks. Apologies for duplicate posts - the system was timing/erroring out and I couldn't tell if they were posting or not.