Hi Eric,

The the following...

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



"Eric" wrote:

Does anyone have any suggestions on how to retrieve the sheet name?
For example, the sheet is named 'Date", I would like to retrieve its name
into cell A1, does anyone have any suggestions?
Thanks in advance for any suggestions
Eric