Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions & Tab Names
My question is simple.
Does anyone out here know of a function that returns the name of a specific TAB in a workbook? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions & Tab Names
I only know of a trick formula that will return the value of the sheet the
formula is entered into: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) What did you have in mind? How would you envision this function working? What are your requirements? -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "HpyTrvlr69" wrote: My question is simple. Does anyone out here know of a function that returns the name of a specific TAB in a workbook? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions & Tab Names
Thank you for your reply RocketSci. I think that will work for what I am doing.
p.s. Im not a Rocket Scientist.....no ..really. "JBeaucaire" wrote: I only know of a trick formula that will return the value of the sheet the formula is entered into: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) What did you have in mind? How would you envision this function working? What are your requirements? -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "HpyTrvlr69" wrote: My question is simple. Does anyone out here know of a function that returns the name of a specific TAB in a workbook? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions & Tab Names
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Entered in a cell exactly as above will return the name of the sheet. Note: workbook must have been saved at least once. Couple more using VBA Sub getname() MsgBox ThisWorkbook.ActiveSheet.Name End Sub Sub get_Sheetname() Dim num As Long num = InputBox("Type a number") MsgBox "Sheet" & num & "'s name is " & Sheets(num).Name End Sub Gord Dibben MS Excel MVP On Mon, 30 Nov 2009 15:09:02 -0800, HpyTrvlr69 wrote: My question is simple. Does anyone out here know of a function that returns the name of a specific TAB in a workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using range names in functions | Excel Worksheet Functions | |||
cell names in functions | Excel Discussion (Misc queries) | |||
IF functions and Names Ranges | Excel Discussion (Misc queries) | |||
working with names and functions | Excel Worksheet Functions | |||
Tracking worksheet names in functions | Excel Worksheet Functions |