T
ton t
Lectori salutem,
In an Excel 2002 workbook I have named formulas, e.g. WeekNumber,
defined (while in cell A2) as
=1+INT((!A1-DATE(YEAR(!A1+4-WEEKDAY(!A1+6));1;5)+WEEKDAY(DATE(YEAR(!A1+4-WEEKDAY(!A1+6));1;3)))/7)
(Thx2 Chris Pearson and Evert van den Heuvel)
It calculates the weeknumber of the date in the cell directly above the
cell containing the formula.
Now whenever I run a macro like J.E. McGimpsey's ListFormulasInWorkbook
(see <http://www.mcgimpsey.com/excel/listfunctions.html>)
the formula results in an error like #VALUE! or #NUM! or even #REF!
Mind you, the formula itself is not the problem, the same occurs with
other even trivial named formula's.
Using <F2> followed by <Enter> corrects the error, but in my actual
application I have hundreds of named formula occurrences like these.
Does anyone recognize this behaviour and what is the solution for it?
Any help would be much appreciated!!
In an Excel 2002 workbook I have named formulas, e.g. WeekNumber,
defined (while in cell A2) as
=1+INT((!A1-DATE(YEAR(!A1+4-WEEKDAY(!A1+6));1;5)+WEEKDAY(DATE(YEAR(!A1+4-WEEKDAY(!A1+6));1;3)))/7)
(Thx2 Chris Pearson and Evert van den Heuvel)
It calculates the weeknumber of the date in the cell directly above the
cell containing the formula.
Now whenever I run a macro like J.E. McGimpsey's ListFormulasInWorkbook
(see <http://www.mcgimpsey.com/excel/listfunctions.html>)
the formula results in an error like #VALUE! or #NUM! or even #REF!
Mind you, the formula itself is not the problem, the same occurs with
other even trivial named formula's.
Using <F2> followed by <Enter> corrects the error, but in my actual
application I have hundreds of named formula occurrences like these.
Does anyone recognize this behaviour and what is the solution for it?
Any help would be much appreciated!!