Putting the TAB (name of the worksheet) in a specified cell

JANICE_SMOKEY · Apr 24th, 2002, 07:32 AM

How can you put the name of the woeksheet (tab) in a specified cell in excel

[ This Message was edited by: JANICE_SMOKEY on 2002-04-24 06:32 ]

GeorgeB · Apr 24th, 2002, 07:38 AM

Put this formula into whatever cell you want the Tab name.

=MID(CELL("filename",G223),FIND("]",CELL("filename",G223))+1,LEN(CELL("filename",G223))-FIND("]",CELL("filename",G223)))

shades · Apr 24th, 2002, 07:39 AM

This will put the worksheet name into any cell reference (in this case A1)

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

JANICE_SMOKEY · Apr 24th, 2002, 08:23 AM

I cannot get either of these to work.

Ricky Morris · Apr 24th, 2002, 09:01 AM

Make sure you're using these formulas in a workbook that has been saved.

lenze · Apr 24th, 2002, 09:07 AM

You can also use VBA code

Range("$A$4")=ActiveSheet.Name

Use this in an event procedure such as Activate or Befor Print, or some other macro

Apr 24th, 2002, 07:38 AM	#2
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Put this formula into whatever cell you want the Tab name. =MID(CELL("filename",G223),FIND("]",CELL("filename",G223))+1,LEN(CELL("filename",G223))-FIND("]",CELL("filename",G223))) __________________ George Learn to listen. Opportunity sometimes knocks very softly.

Apr 24th, 2002, 07:39 AM	#3
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	This will put the worksheet name into any cell reference (in this case A1) =MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,255) __________________ - old, slow, and confused ... but at least I'm inconsistent - (retired Excel 2003 user, 3.28.2008)

Apr 24th, 2002, 09:01 AM	#5
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Make sure you're using these formulas in a workbook that has been saved. __________________ 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 24th, 2002, 07:32 AM	#1
JANICE_SMOKEY New Member Join Date: Apr 2002 Posts: 3	How can you put the name of the woeksheet (tab) in a specified cell in excel [ This Message was edited by: JANICE_SMOKEY on 2002-04-24 06:32 ]

Apr 24th, 2002, 08:23 AM	#4
JANICE_SMOKEY New Member Join Date: Apr 2002 Posts: 3	I cannot get either of these to work.

Apr 24th, 2002, 09:07 AM	#6
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	You can also use VBA code Range("$A$4")=ActiveSheet.Name Use this in an event procedure such as Activate or Befor Print, or some other macro