empty arguments recalculation - microsoft.public.excel.worksheet.functions

While using a macro for some user defined functions, it happens that it returns an error, or in the worst case, excel (2007) stops running at all. Through debugging I find that one or several arguments passed to VBA by reference appear to be empty, although they are correctly referred. I assume this empty arguments are non recalculated references. Somehow, in some cases the function macro seems to be recalled as many times as necessary to complete previous reading of the missing arguments. I assume that this is because the worksheet is recalculated automatically until all arguments are passed as required by the macro. It is magic for me how the situation in some cases gets suddenly stabilized, and the macro works when all inputs in the worksheet are quiet, but if a precedent input changes the application stop running again, requiring to be restarted once and once again. My guess is that I have not been able to decipher completely the excel recalculation rules, but I have not found anywhere some explanation about how this work. I will highly appreciate your assistance. Thank´s for help JS -- Thank´s for help JS

See responses in m.p.e.programming. For the future, please do not multipost. ----- original message ----- "Jorge Suzan" <JorgeSuzan@discussions.microsoft.com> wrote in message news:262A9E87-415C-4914-BFEF-ED2AC84BE01D@microsoft.com... > While using a macro for some user defined functions, it happens that it > returns an error, or in the worst case, excel (2007) stops running at all. > > Through debugging I find that one or several arguments passed to VBA by > reference appear to be empty, although they are correctly referred. > I assume this empty arguments are non recalculated references. > > Somehow, in some cases the function macro seems to be recalled as many > times > as necessary to complete previous reading of the missing arguments. I > assume > that this is because the worksheet is recalculated automatically until all > arguments are passed as required by the macro. > > It is magic for me how the situation in some cases gets suddenly > stabilized, > and the macro works when all inputs in the worksheet are quiet, but if a > precedent input changes the application stop running again, requiring to > be > restarted once and once again. > > My guess is that I have not been able to decipher completely the excel > recalculation rules, but I have not found anywhere some explanation about > how > this work. > > I will highly appreciate your assistance. > Thank´s for help > JS > -- > Thank´s for help > JS

Similiar Articles:

Resource Leveling - microsoft.public.project
... professor warned about the pitfalls of what he called "empty precision" and I think the argument ... What you would like to do is have project recalculate the durations ...

Excel User-Defined Functions - Decision Models
Calculates more than once in a recalculation, the Function Wizard ... abandon calculation not only if ALL the input arguments are uncalculated/empty ...

Excel Recalculation
The user can trigger recalculation in Microsoft Excel in several ways, for example: ... be assumed to be the same from one moment to the next even if none of its arguments ...

xlfRegister (Form 1)
... hidden name which is the function text argument, ... passed when the caller passes a reference to an empty ... Excel 2007 can perform multithreaded workbook recalculation.

Resolver One Feature Overview - Resolver Systems
It can also reload the data and recalculate whenever the database changes. ... Returns TRUE if the single argument is the special value Empty, and FALSE otherwise.

TODAY & NOW Functions/Formulas.Excel Volatile Functions Level 1 ...
A workbook will also recalculate whenever we open or save. No Arguments. As you are now aware, most of Excels ... In other words we enter them with empty parenthesis. As an ...

7/17/2012 5:31:30 AM