Debug my code

[jwp]

The code works but gets stuck on this sql query, getting pop up box saying Code Execution has been interrupted I press continue and it works perfectly and produces the desired output.

Any ideas

strH = "select PERSON.POSITION, JCTRAN.MATTER_NO, sum(JCTRAN.UNITS)as UNITS, sum(JCTRAN.BILLED_AMOUNT)as BILLED_AMOUNT" _
& " From PERSON Inner Join JCTRAN On PERSON.CODE=JCTRAN.PERSON_CODE" _
& " Where JCTRAN.MATTER_NO='" & sCode & "'" _
& " Group By PERSON.POSITION, JCTRAN.MATTER_NO"

 

[nightcrawler23]

try adding this line

Application.displayalerts = false

at the start of your code
and

Application.displayalerts = false

at the end.

 

[jwp]

The error just moves to the first

Application.DisplayAlerts = False

 

[jwp]

Was the Visual Basic editor I rebooted my computer now it works. Closing and restarting Ecel did not fix. One to remember, thanks.