Post the code, not an attachment.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"TY" wrote in message
...
The problem is when updating the source value of an UDF's argument will
result in #NAME.

1. Open test#NAME.xla
2. Open test#NAMEwkbk.xls in automatic calculation mode
3. Change the cell A4 to "blah"
4. Notice UDF in B4 is changed to #NAME, which is expected to be 100.5

Anyone knows why?

Thanks.

Teresa