That did the trick. Code is working as expected. As always, thank you and all others that take the time out of their day to help others with Excel issues.

P.S. I really liked your advice for setting breakpoints. This was something I did not know even existed before you made your comment. This is really helpful for debugging.

Err_CommandButton1_Click:
    Select Case Err.Number
        Case 10000
            MsgBox Err.Description
            j = j + 1
            i = i + 1
        Case 10001
            'invalid interval
            MsgBox Err.Description
            j = j + 1
            i = i + 1
        Case 10002
            'query failed
            MsgBox Err.Description
            j = j + 1
            i = i + 1
       Case Else
            MsgBox "Invalid Search Parameters or other error.  No data was returned."
            j = j + 1
            i = i + 1
    End Select
    Resume