On my spreadsheet, cell A1 has the following formula: =cell("filename). The result is:
\Admin2-ladontemp[Copy of 0904-CAPITAL AVIATION.xls]Summary Sheet
How would I get the phrase "Summary Sheet", to appear in Cell A1? Also, is there a formula that can just print the name of a particular worksheet in a workbook?
Thanks for all of your help
Law
\Admin2-ladontemp[Copy of 0904-CAPITAL AVIATION.xls]Summary Sheet
How would I get the phrase "Summary Sheet", to appear in Cell A1? Also, is there a formula that can just print the name of a particular worksheet in a workbook?
Thanks for all of your help
Law