Error Message with For Loop

Hi,

I am trying to create a loop that deletes rows within my worksheet. However, the data in the spreadsheet will change every month so I can't add definite ranges in my code. The code below works but when it finished I get a runtime error '10004' message. Please help me here.

Thanks!

HTML Code: