Name tab in cell in excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hallo

with the following user defined function:

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

greetings
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
How to put several sheet into one sheet. 3
Continuous Invoice Nos. 3
How do i use the same cell name accross multiple tab names in a wo 8
Sheet tab names change automatically 3
Copy a cell from a diferent tab when the tab name is in a cell 2
Printing Excel File Custom Properties in the Footer 3
Problem tabbing between merged cells in Excel 2010 0

Back
Top