Name tab in cell in excell

F

Frode Hjartøy

Hello

I wish to insert av column in many sheet. I wish to do this in a macro.

My problem is print the sheet name in one cell.

In headder and footer you can use "&[Tab]"

How can I get this function in excel.

Best regards Frode
 
F

Frederik

Hallo

with the following user defined function:

Public Function TabName() As String
Application.Volatile
TabName = Application.Caller.Parent.Name
End Function

greetings
 
Top