A UDF (User Defined Function) is a VB function that is called from by a
worksheet formula. Say you put this function in a VB module:

Function IncrementNumber(Num as Double) As Double
IncrementNumber = Num + 1
End Function

And in a worksheet cell you enter =IncrementNumber(1).

This should return 2.

These things should work just fine but I've seen enough weirds things with
UDFs that I will not use them.

Calc mode - I'm referring the Automatic versus Manual calc. The setting
under Tools, Options, Calculation. If it's set to Manual when a macro runs
and you do not force a calc via the Calculate method then any UDFs, if you
have any, would not be called.

--
Jim
"Joe" <jyothis@vt.edu> wrote in message
news:1139438020.272029.33190@g43g2000cwa.googlegroups.com...
| Thanks, Jim. I'd already fixed it by inserting a break and then
| removing the break, but still, out of curiosity, what is a UDF ? Also,
| when you asked me to "make calc mode manual", how can I do it - I mean,
| how do I change that "mode" ?
|
| Thanks,
|
| Joe.
|