Sheet Function

  • Thread starter Thread starter Ruan
  • Start date Start date
R

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
 
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
 
Back
Top