Quick (easy) question....

[Robin]

Hi,

Is there a function I can use that returns the sheet tab name?

There must be! Thanks in advance guys.

Robin

[Nibbles]

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

[Aladin Akyurek]

On 2002-04-29 02:06, Robin wrote:
Hi,

Is there a function I can use that returns the sheet tab name?

There must be! Thanks in advance guys.

Robin

In some cell or even in A1 in the target sheet enter:

=CELL("filename",A1)

In A2 enter:

=MID(A1,SEARCH("]",A1)+1,LEN(A1)-SEARCH("]",A1))

where A1 houses the first formula.

[Nibbles]

Sweet. I didn't know about 'filename'!

Nibbs