Microsoft KB Archive/180370

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

Article ID: 180370

Article Last Modified on 9/12/2006

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q180370





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.



WORKAROUND
To work around this problem, use the Value property instead of the Text property in the custom function.



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.

Additional query words: XL98 vba

Keywords: kbbug KB180370

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.