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? |
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? |
All times are GMT +1. The time now is 02:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com