MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Active Sheet Tab

Posted by Paul Magruder on December 20, 2000 6:02 PM

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

Posted by Celia on December 20, 2000 11:47 PM

ActiveSheet.Name = "Whatever"