Just recently I've posted the same file in this forum and now I've got another example that



the run-time result is just different from what I can get when I step into the codes pressing F8 every time. It drives me crazy cos it wastes all of my time (a few hours) to make sure the codes run well before run-time. When I press F5 to run it all, it just differs and I am totally frustrated here.

Please help take a look at the file (see the comments in the codes for the problem) and if you can walk me through this problem, I would be very thankful for your help. It does help me understand VBA far better.

Many thanks in advance.

Attached Files

Application Data - Copy.xlsm (28.6 KB, 11 views)