Then in cell B2 enter the formula =INDEX(SheetNames,), and then copy and paste the formula down 25 rows These formulas will return a list of the names of your worksheet tabs in the same order as your worksheet tabs (Note The workbook must be saved as an Excel MacroEnabled Workbook file type in order to retain the Defined Name formula) There are formulas for each variation of the sheet name, file name and path The main part of the formula is the =CELL () formula The CELL formula looks something like this =CELL ("filename",A1) That means that the CELL formula we have to use has two parts The first part just says "filename" It is important to add the quotation marks If all of the worksheets are in the same workbook, try using the INDIRECT function (refer to inbuilt help for syntax) Rgds, ScottO "kojimm" wrote in message news5BC62FEAEE12A605F7F6CE8@microsoftcom I use the folowing formula in a summary sheet that looks at specific cells on other work sheet
How To Correct A Name Error