Help with 'named' functions

[Simon]

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

 

[Niek Otten]

Without a bit more insight in formulas, named formulas and code it is
difficult to advise.

Can you provide some more details?

 

[Simon]

Without a bit more insight in formulas, named formulas and code it is
difficult to advise.

Can you provide some more details?

apologies for not providing more details, it's always a little hard to know
how much to include...

I have attached a copy of a single page workbook (again, apologies if this is
against the group conventions, but I have no other way of sharing the
code/sheet) which includes both a 'working' example of one of my sheets, and
the code I use to build it.

Using Office 2000 (pro)

Hope this helps

many thanks

S