N
Nenad Tosic
Hello all,
this time I will be much shorter:
Is there any way that I can "handle" errors. When Excels' <function> returns
error ("#NUM!") (in a worksheet)
I may type in a cell "=IFERROR(<function>; -5.0) (my local settings needs
semicolumn as argument separator)
in order to display either value that <function> returns (if it is not
error) or -5.0 if it returns error of some types
("#N/A", "#VALUE!", "#REF!", "#DIV/0!", "#NUM!", "#NAME?" or "#NULL!")).
Is there any mechanism that I may use in order to "catch" error that returns
"WorksheetFunction.<function>"
inside VBA code (User Defined Function)? If I type something like:
X=WorksheetFunction.IsError(WorksheetFunction.<function>, -5.0)
and step through UDF ("F8") everything is OK, variables get their proper
values, ... until that assignment, if <function>
returns "#NUM!". If <function> returns some "proper" value everything is OK
until next assignment in thich <function>
returns "#NUM!". My UDF simply "exits", all variables lose their values, as
if function is exited (normaly or abnormaly).
Thanks in advance
Nenad
this time I will be much shorter:
Is there any way that I can "handle" errors. When Excels' <function> returns
error ("#NUM!") (in a worksheet)
I may type in a cell "=IFERROR(<function>; -5.0) (my local settings needs
semicolumn as argument separator)
in order to display either value that <function> returns (if it is not
error) or -5.0 if it returns error of some types
("#N/A", "#VALUE!", "#REF!", "#DIV/0!", "#NUM!", "#NAME?" or "#NULL!")).
Is there any mechanism that I may use in order to "catch" error that returns
"WorksheetFunction.<function>"
inside VBA code (User Defined Function)? If I type something like:
X=WorksheetFunction.IsError(WorksheetFunction.<function>, -5.0)
and step through UDF ("F8") everything is OK, variables get their proper
values, ... until that assignment, if <function>
returns "#NUM!". If <function> returns some "proper" value everything is OK
until next assignment in thich <function>
returns "#NUM!". My UDF simply "exits", all variables lose their values, as
if function is exited (normaly or abnormaly).
Thanks in advance
Nenad