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

"Ruan" wrote in message
...
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