Adding A Blank Row To A Table In Error

Thank You for your reply. This was another good learning moment. I had used debug, or at least my limited understanding of its capabilities, to no avail. Knowing the offending code lead me to apply a break point their so I could see it add the line. My question is, if you don’t mind, how do you apply a systematic approach to using debug that leads you to this line?

I have stripped out many functions and lines of code to provide this example…(My coding is at best, my attempt to learn VBA and at worst a mishmash of code that I have gotten from the internet that I have slim knowledge of how it functions. Neither of which represents a clear style or approach.) The original would have been more difficult to weed through so a little insight into how you approach the problem solving process would be of great benefit.

The solution to this problem…. Or at least what I did that worked, was to move that line of code to the If statement which adds data to Table 2. Is that a proper fix or should I have declared something different at the beginning?

Thank You again…. One day, I might be able to answer questions…. But not for the foreseeable future.

Best Regards
Scott