G
Guest
Guest
Is there a way to display a sheet name in a
cell
cell
On 2002-03-05 13:53, Anonymous wrote:
Is there a way to display a sheet name in a
cell
On 2002-03-05 14:52, davers5 wrote:
Or in one cell:
=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))
Cell("filename"), I just learned, returns the path to your file including the current sheet that is active, with the workbook in brakets (so the end of the path looks like this: [book1]Sheet1). The right function cuts out the rest of the path and leaves you with just the sheet. However, if the workbook you are working with HAS NOT BEEN SAVED, the cell("filename") function will return a blank string (""). If you were having trouble with this, make sure you save the workbook.
Dave