Easy one

Mr. Guy · Apr 11th, 2002, 12:48 PM

All I need to do is have a cell that displays the worksheet name.

I figured "=sheetname" or something to that effect. I've been checking for a while and oddly enough I can find no answers.

lantiger · Apr 11th, 2002, 12:51 PM

you are on the right track, if you just want the name of the active sheet, then the following code will work

ActiveSheet.Range("A1") = ActiveSheet.Name

hth
lantiger

Ricky Morris · Apr 11th, 2002, 12:57 PM

This can also be accomplish with the following formula rather than vba.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

Apr 11th, 2002, 12:57 PM	#3
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	This can also be accomplish with the following formula rather than vba. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 12:48 PM	#1
Mr. Guy New Member Join Date: Mar 2002 Posts: 18	All I need to do is have a cell that displays the worksheet name. I figured "=sheetname" or something to that effect. I've been checking for a while and oddly enough I can find no answers.

Apr 11th, 2002, 12:51 PM	#2
lantiger New Member Join Date: Apr 2002 Posts: 24	you are on the right track, if you just want the name of the active sheet, then the following code will work ActiveSheet.Range("A1") = ActiveSheet.Name hth lantiger