i need the sheetname in my cells
Thank you.
"Biff" wrote in message
...
Well, you could get it with a VBA user defined function but why would you
if there is a built-in function.
Biff
"Kiklop" wrote in message
...
That means that the sheetname is available only with the CELL function?
"Biff" wrote in message
...
Don't know if it's any better:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)*1
Biff
"Kiklop" wrote in message
...
I am using numbers for sheetnames and I need them in a cell in this way
=VALUE(RIGHT(CELL("filename";A3);2))
Is there any another way to put the sheetname into the cell?
|