I have some code that builds a workbook on the fly.

The book is used for calculating/checking costs against a fixed
price/discount and would routinely carry between 20K and 50K records.

Because of the volume of data and the number (and complexity) of
calculations it is impractical to use formula's directly in the cells (and
doing it from code is worse), so I have incorporated 'named' functions.

Again, this all works as expected until you add some data to a sheet, at
which point you get a "#NAME?" error, indicating to me that the name doesn't
exist...

If I then go to INSERT|NAME|DEFINE and select each of the functions in turn
and press add, everything comes good (note, I have not changed anything in
the functions, just 're-added' them).

I don't know what's causing this, which makes it rather hard to fix....

anyone got any ideas (please - I've spent a lot of hours trying to get the
damn thing this far!!)

many thanks (in advance)

S

-------------------------------------
2+2 will never equal 5
(not even for very large values of 2)
-------------------------------------