How to debig a UDF
 

I have a former coworker's spreadsheet. It has a UDF which is returning
#Value. How do you debug this? I have Excel 2003 and I've tried the evaluate
formula but it wals through the first argument and then goes to #value beyond
that.

How do you debug a UDF?
--
DRK

How to debig a UDF
 

Go to the Visual Basic window (alt+F11) and locate the UDF. Place a
breakpoint at the first line of executable code (highlight anything on the
row and press F9). Go back to a cell using the function, put your cursor in
the formula bar, and hit Enter on your keyboard. This SHOULD begin execution
of the macro, and the VB window will jump to your breakpoint. Then you can
use F8 to page through line by line and discover the calculation error.
--
Hmm...they have the Internet on COMPUTERS now!


"DRK" wrote:

I have a former coworker's spreadsheet. It has a UDF which is returning
#Value. How do you debug this? I have Excel 2003 and I've tried the evaluate
formula but it wals through the first argument and then goes to #value beyond
that.

How do you debug a UDF?
--
DRK

How to debig a UDF
 

Got it. Thanks.
--
DRK


"MDW" wrote:

Go to the Visual Basic window (alt+F11) and locate the UDF. Place a
breakpoint at the first line of executable code (highlight anything on the
row and press F9). Go back to a cell using the function, put your cursor in
the formula bar, and hit Enter on your keyboard. This SHOULD begin execution
of the macro, and the VB window will jump to your breakpoint. Then you can
use F8 to page through line by line and discover the calculation error.
--
Hmm...they have the Internet on COMPUTERS now!


"DRK" wrote:

I have a former coworker's spreadsheet. It has a UDF which is returning
#Value. How do you debug this? I have Excel 2003 and I've tried the evaluate
formula but it wals through the first argument and then goes to #value beyond
that.

How do you debug a UDF?
--
DRK