VBA Debug Mode : How to I enter it after executing the nth data row.

U

u473

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
 
N

Nayab

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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top