I had not saved the file as an xlsm file I'm new to Excel 07 and my employer has Excel configured to save as xls files by default because not everyone is switched over yet I didn't realize that files with macros had to be saved as xlsm files Thanks for the information It is a huge help to me to have this issue resolvedTomThe Excel ISNONTEXT function returns TRUE when a cell contains any value except text This includes numbers, dates, times, errors, and formulas that do not return text ISNONTEXT also returns TRUE when a cell is emptyFollowing the Excel help for "Correct a #NAME?
Excel Formula List Sheet Names With Formula Exceljet
