I'm with JE in that without seeing it it's very hard to do much about it,
albeit given you have multiple named formulas you would have to list those
too.

That having been said, if it's really evaluating correctly initially and
then failing as you copy down, then that is usually a sign of having a range
in the formula that is relative when it is supposed to be absolute. Any
chance that could be the case?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip