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
