UDF only have calculation issues if you are referencing worksheet cells
inside a UDF that are not passed as a parameter. the fix is easy by passing
all the worksheet cells through the calling parameters.

"ytayta555" wrote:

On 7 Aug, 13:45, Joel wrote:
I have found that worksheet functions are usually very effient unless there
is a less complicated method using a UDF. If you have a UDF it is more
efficient to use macro code rather than call a worksheet function when there
ae equivalent methods. It also doesn't use much overhead to call a worksheet
function.


Indeed , UDF have problem with recalculation , the problem of volatile
formula ,
can occure wrong results ,....; I'll try to see the best method , but
in time ;
maybe you can show me how is to use a macro ...
( If you have a UDF it is more
efficient to use macro code rather than call a worksheet function when there
ae equivalent methods. It also doesn't use much overhead to call a worksheet
function. )
... to understand what is in this ideea .

Thanks so much you initiate me in this new method for me !!

Maybe , another last method and the best is to use , according with
this .....[ Another thing to keep in mind is that a UDF will more
often than
not be less efficient than a deeply nested group of standard
Functions.
This is because Excel's built in Functions are written in the
extremely
fast language, C++. VBA, unfortunately, is a very slow programming
language.]
...according with this , to use C++ for my database .Now , my database
is
in Excel application and VBA programming language , but it isn't
bad ! ...

Many thanks again mr. Joel , any ideea and sugestion here is very
apreciated
and usefull for me