Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 184
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default 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 !
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bug using Help in debug mode ? Patachoup Excel Programming 1 June 5th 07 12:19 PM
Getting Kicked out of Debug mode J Streger Excel Programming 0 May 24th 07 02:59 PM
Get in DEBUG mode on workbook open Anthony Fok[_2_] Excel Programming 5 July 28th 05 06:30 PM
Debug Step vs Run Mode Arthur[_3_] Excel Programming 3 November 9th 03 05:03 PM
Mysterious debug mode Shunt Excel Programming 0 August 7th 03 02:35 PM


All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"