try =CELL("filename",A1) for all the info or
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) if you just
want the sheet name.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Curtis" wrote:

Is there a command that I could that would paste the name of an excel
workbook and worksheet into the body of the spreadsheet, say cell a4 and a5

Simular to when you print the file name and tab name when printing

Thanks

ce