You created a Do loop, but did not include the associated While or Until keywords. The test condition of a Do loop requires either a While or an Until keyword in the test condition statement. The following demonstrates the correct structure of a Do loop.
Do [{While | Until} condition] [statements] [Exit Do] [statements] Loop
Or, you can use this syntax:
Do [statements] [Exit Do] [statements] Loop [{While | Until} condition]
To correct this error
Looping Through Code | Do...Loop Statement | For...Next Statement | For...Next Statement | While...Wend Statement | Exit Statement