S Sheeloo Sep 15, 2008 #2 =CELL("filename") Go to http://office.microsoft.com/en-us/excel/HA010346271033.aspx
C Corey Sep 15, 2008 #3 Thanks Tried that origianlly but only displayed the 'CELL("filename")' as text., Is Ok now Thank You Corey....
Thanks Tried that origianlly but only displayed the 'CELL("filename")' as text., Is Ok now Thank You Corey....
D Dave Peterson Sep 15, 2008 #4 =cell("filename") will evaluate to the workbook name that was active when excel recalculated. =cell("filename",a1) will return that workbook/worksheet for the cell with the formula. You can visit Chip Pearson's site for a bunch of formulas: http://www.cpearson.com/excel/excelF.htm#FileName ps. The workbook has to be saved at least once.
=cell("filename") will evaluate to the workbook name that was active when excel recalculated. =cell("filename",a1) will return that workbook/worksheet for the cell with the formula. You can visit Chip Pearson's site for a bunch of formulas: http://www.cpearson.com/excel/excelF.htm#FileName ps. The workbook has to be saved at least once.
