Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracing into a Function
i have a function that i created. I would like to debug
the function and trace/step into the function to determine when the problem is. however, the "Step in" option is not valid when i show the calculation steps. How can I debug this function? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracing into a Function
Adrian,
Put a breakpoint (select the line, then F9) on the first line of code in the function, then call the function either from a worksheet cell or another VBA procedure. Then, you can use F8 to step through the function. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Adrian McCray" wrote in message ... i have a function that i created. I would like to debug the function and trace/step into the function to determine when the problem is. however, the "Step in" option is not valid when i show the calculation steps. How can I debug this function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tracing precedents | Excel Worksheet Functions | |||
Formula Tracing | Excel Discussion (Misc queries) | |||
Looking for alphabet tracing | Excel Discussion (Misc queries) | |||
Tracing precedents | Excel Worksheet Functions | |||
Tracing Dependents | Excel Discussion (Misc queries) |