| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to insert tab name of a wrksht into a cell in that worksheet?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to insert tab name of a wrksht into a cell in that worksheet?
Check out this web page of J.E. McGimpsey:
http://www.mcgimpsey.com/excel/formu..._function.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pat" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to insert tab name of a wrksht into a cell in that worksheet?
Pat,
Use a formula like =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) The A1 is required, but can actually be any cell you want. This requires that the file has been saved to disk at least one (that is, it won't work on new, unsaved workbooks). -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Pat" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a hotlink to go from one cell to another in a wrksht | Excel Discussion (Misc queries) | |||
| how do I get the cell to move to the right instead of the wrksht? | Excel Worksheet Functions | |||
| Shade a cell on one wrksht if another wrksht cell is occupied | Excel Worksheet Functions | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| 3 pg excel wrksht,pg 2 prints formula answers,insert pic behind | Excel Discussion (Misc queries) | |||
Hybrid Mode
