| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have a cell just quote the worksheet name?
Ie. My workbook has 5 worksheets, England, Scotlans etc
Can I have cell A7 of each sheet just quote the name? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to have a cell just quote the worksheet name?
You Could have something like this in cell A7 in each worksheet
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,30) regards Paul DannyS wrote: Ie. My workbook has 5 worksheets, England, Scotlans etc Can I have cell A7 of each sheet just quote the name? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to have a cell just quote the worksheet name?
This, in any cell will return the SheetName, once the file has been saved.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) Vaya con Dios, Chuck, CABGx3 "DannyS" wrote: Ie. My workbook has 5 worksheets, England, Scotlans etc Can I have cell A7 of each sheet just quote the name? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to have a cell just quote the worksheet name?
Super, thanks guys "CLR" wrote: This, in any cell will return the SheetName, once the file has been saved. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) Vaya con Dios, Chuck, CABGx3 "DannyS" wrote: Ie. My workbook has 5 worksheets, England, Scotlans etc Can I have cell A7 of each sheet just quote the name? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Linear Mode
