[SOVLED] Error 1004 "Application Defined or Object Defined Error"

Hi, I'm new to writing macros in Excel and I'm trying to write on that iterates through the rows of an excel file until it matches a string, and delete all the rows before the string. Below is my code:

Please Login or Register  to view this content.

However, when I run the macro on my test spreadsheet, I get an error on the If statement saying there is an 'object defined error'. What does this mean? Thanks!

Please put your code in code tags. Edit your post, highlight the code, then press the # button in the text editor's toolbar.

Anyway, the error is because Range(i) is not a range. You'd need something like

Please Login or Register  to view this content.

Also, you don't want to set i = LR before you loop. If you did that, you'd only go through your Do loop once. You can either move that to before the Else, or just remove that and put an Exit Do before the Else.


Edit: By the way, here is a MUCH faster approach than iterating through every cell, especally if your search result is hundreds of rows or more down the sheet:

Please Login or Register  to view this content.