Sheet Function

[Ruan]

Hello,

Is there a function that will give you the sheet name in a cell? (Example:
A1)

I would like to write an IF statement that will refer to Sheet Names.

Thanks
Ruan

 

[T. Valko]

Try this:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Note: the file must already exist. In other words, the workbook must have
been saved and given a file name.

Biff