Get Sheetname in Formula

[John Yazou]

Hi,
Just a quick one.. tried the archives, but can't seem to find the answer..
How do I get the current sheet name using formulas instead of vba??
Thanks!

 

[brettacook]

This
CELL("filename")
Is a Volatile function, it recalculates every time anything is changed in the book.
Any time anything changes on any sheet, then Cell("filename") is recalcuated (on ALL sheets)
But it returns the sheet of whichever sheet is currently active to ALL occurances of the Cell("filename") function.


By changing it to
CELL("filename",A1)

That "Ties" the Cell function to a cell on that sheet.
So each one on each sheet is dependant on the A1 in it's own sheet.

Thanks so much for this one! I was having the exact problem described (i.e. all sheets used the same value) - this solved my problem for me!

 

[EdwardsBueno]

Hello, here are 3 different ways to get the same result:

1. =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-(FIND("]",CELL("filename",A1))))
2. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,1000)
3. =REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

These will be dynamic!