| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tabs
Hi
Any ideas how I can get a cell in excel 2007 to automatically insert whatever the tab name is? Thanks Dale |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tabs
This will work only on a workbook that has been opened from the hard disk
(in other words, the workbook must have been saved at least one time any time in the past)... =TRIM(RIGHT(SUBSTITUTE(CELL("filename",A1),"]",REPT(" ",99)),99)) -- Rick (MVP - Excel) "Dale" wrote in message ... Hi Any ideas how I can get a cell in excel 2007 to automatically insert whatever the tab name is? Thanks Dale |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Tabs
Thanks that's just the ticket
"Rick Rothstein" wrote in message ... This will work only on a workbook that has been opened from the hard disk (in other words, the workbook must have been saved at least one time any time in the past)... =TRIM(RIGHT(SUBSTITUTE(CELL("filename",A1),"]",REPT(" ",99)),99)) -- Rick (MVP - Excel) "Dale" wrote in message ... Hi Any ideas how I can get a cell in excel 2007 to automatically insert whatever the tab name is? Thanks Dale |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
| Can we modify any of the ribbon tabs or create new ribbon tabs? | New Users to Excel | |||
| hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
| Tabs | Excel Discussion (Misc queries) | |||
| Can i set up tabs within tabs on Excel? | Excel Worksheet Functions | |||
![Dale[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
