Microsoft KB Archive/213679

= XL2000: Custom Function Returns #VALUE! Error After Running Macro =

Article ID: 213679

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213679





SYMPTOMS
If you call a user-defined (custom) function from a worksheet formula, and then run a Microsoft Visual Basic for Applications macro, the user-defined function may return the #VALUE! error.



CAUSE
This problem occurs if all of the following conditions are true:
 * You create a custom function, and then call it from a worksheet formula.

-and-
 * The custom function uses the Text property for a Range object.

-and-
 * You run another Sub procedure (macro) that deletes a row in the worksheet.



RESOLUTION
To resolve this problem, use the Value property instead of the Text property in the custom function.

NOTE: If you must use the Text property, recalculate the formulas in the workbook by pressing CTRL+ALT+F9.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
You can use the Text property or the Value property with a Range object. The Value property returns the actual underlying cell value, while the Text property returns the formatted value that is displayed in the cell.

