MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sheet name to be automatically reflected in Body of sheet


Posted by Steve Venter on January 24, 2002 4:30 PM

Hi,

What formula can be used to display the sheet name i th body of an Excel spreadsheet?

Thanks


Posted by Jacob on January 24, 2002 5:05 PM

Hi

In VBA

Insert this in the sheet code for the sheet you want

Sheet_Activate()
Range("A1").formulaR1C1 = activesheet.name
end sub

HTH

Jacob

Posted by anno on January 24, 2002 6:33 PM

or you could use =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"),1)) [nt]