| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name tab in cell in excell
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name tab in cell in excell
Hallo
with the following user defined function: Public Function TabName() As String Application.Volatile TabName = Application.Caller.Parent.Name End Function greetings "Frode Hjartøy" schreef in bericht ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add a picture to excell cell | Excel Discussion (Misc queries) | |||
| split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
| Excell- a value in a cell, round it up by fives in another cell | New Users to Excel | |||
| Excell will not move from cell to cell with arrows, only scrolls | Excel Discussion (Misc queries) | |||
| Formating a cell in Excell | Excel Worksheet Functions | |||
Linear Mode
