MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Show tab name in A2


Posted by Eugene Robinson on December 24, 2001 6:03 AM

After renaming a tab how can I ensure it will always show in cell A2 ?


Posted by jacob on December 24, 2001 1:53 PM

Try this

In the code for the sheet you want to do this.

sub worksheet_change, or worksheet_activate

range("A2").formulaR1C1 = activesheet.name

end sub