need breakpoint to stop code

[Souris]

I have some code to fill the excel spreadsheet from Access table.

The code fill the first record, but I need set break point ansd stop then
Excel fill the second record.

If I do not stop at the break point then it just fills one record.

I am not sure are there any sleep command to let it wait.
Is it possible it was too fast to fill second record?

Your information is great appreciated,

 

[Chip Pearson]

You can use Debug.Assert to break when some condition if false. For example,
if you have a counter N that counts the number of records, you can use

Debug.Assert N<>2

to break when N equals 2.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)