"Object required" error with VBA loop rows deleting

[JKWIN]

The macro below should remove rows with text in column "A" containing "1" digit(e.g. A1, AB1) and rows below it, if cell in column "A" is empty and cell in column "K" is not empty. When there is a row with "1" and one row below it- macro removes this row below, then the error appears: "object required" and a row with "1" is not removed. When there are only rows with "1" without these rows below - it is ok, the rows are removed.
Someone helps?

Please Login or Register  to view this content.

[tangangtanga]

@ts I suggest you attached the file so that the macro can easily be changed within the excel file you are using.

[Cutter]

Hello JKWIN, and welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules (Rule #3) require them so please keep that in mind and add them yourself whenever showing code in any of your future posts.
Thanks.

RULE 3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[JKWIN]

That's the file.

[tangangtanga]

hi kindly check this macro.. please inform me if this helps.

Please Login or Register  to view this content.