Sheet Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ruan - 26 Jan 2007 06:33 GMT

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

Reply to this Message

T. Valko - 26 Jan 2007 07:03 GMT

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

> Hello,
>
[quoted text clipped - 5 lines]
> Thanks
> Ruan

Reply to this Message