![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Feb 2002
Posts: 16
|
Hi,
Is there a function I can use that returns the sheet tab name? There must be! Thanks in advance guys. Robin |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Apr 2002
Location: Surrey, United Kingdom
Posts: 75
|
Hi,
There is not a function that I know of, but someone here may well know of one. I know you can use VBA to do it. If you wanted cell A1 to display the tagname you could use: Sub Insert_Tag_Name() ActiveSheet.Range("A1") = ActiveSheet.Name End Sub Hope this helps, Nibbs |
|
|
|
|
|
#3 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,317
|
Quote:
=CELL("filename",A1) In A2 enter: =MID(A1,SEARCH("]",A1)+1,LEN(A1)-SEARCH("]",A1)) where A1 houses the first formula. |
|
|
|
|
|
|
#4 |
|
Board Regular
Join Date: Apr 2002
Location: Surrey, United Kingdom
Posts: 75
|
Sweet. I didn't know about 'filename'!
Nibbs |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|