| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the current directory for existing worksheet?
Does anyone have any suggestions on how to display the current directory for
existing worksheet in cell A1? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display the current directory for existing worksheet?
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1)
-- David Biddulph "Eric" wrote in message ... Does anyone have any suggestions on how to display the current directory for existing worksheet in cell A1? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I display the current worksheet name in a cell? | Excel Worksheet Functions | |||
| display current cell contents in another worksheet | Excel Worksheet Functions | |||
| How to get current worksheet name to display in a cell? | Excel Worksheet Functions | |||
| Display multiple tabs in current worksheet | Excel Worksheet Functions | |||
| Insertion of existing worksheets in current worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
