Active Sheet Tab

Is there code that will select the ActiveSheet Tab without using the sheets name? I am using a macro to rename the sheet, but need o highlight the tab first,
before pasting the new name.

I am using Excel 97

Thanks in advance
Paul Magruder