Worksheet Tab Value

[rfronz]

Hello, can anyone tell me how to get the value of what i call a worksheet tab into a cell automaticly?

i have seen it done but can not recreate it.

thanks
Rob

[EdMac]

Rob,

Try this

=MID(CELL("filename",A1:A1),(FIND("]",CELL("filename",A1:A1))+1),(LEN(CELL("filename",A1:A1))-FIND("]",CELL("filename",A1:A1))+1))

Ed