ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Debug Mode : How to I enter it after executing the nth data row. (https://www.excelbanter.com/excel-programming/412721-vba-debug-mode-how-i-enter-after-executing-nth-data-row.html)

u473

VBA Debug Mode : How to I enter it after executing the nth data row.
 
My program performs well until I reach execution of data row # 1378.
My loop seems to be misbehaving after that row but I have no clue on
what triggered it.
Please remind me how do I enter automatically in VBA Debug Mode after
executing
the nth data row to be able to start checking Watches.
Thank you,
Wayne

Nayab

VBA Debug Mode : How to I enter it after executing the nth datarow.
 
On Jun 17, 5:55*pm, u473 wrote:
My program performs well until I reach execution of data row # 1378.
My loop seems to be misbehaving after that row but I have no clue on
what triggered it.
Please remind me how do I enter automatically in VBA Debug Mode after
executing
the nth data row to be able to start checking Watches.
Thank you,
Wayne


An alternative is to display a Msgbox when the row count is n and as
the msgbox gets displayed u can press ctrl+break and then it will take
u to the debug mode and then u can put all the break points !


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com