Delete Entire row by vba (macro Correction)

[dumdumbum]

Please Login or Register  to view this content.

I have a macro to do the same but it is not deleting the entire row so plz see & help me out in the same

[davesexcel]

What do you mean "It is not deleting entire row"? it only deletes part of the row?

[vba_php]

dave probably knows more about me than this, however this was the code that you posted:

Please Login or Register  to view this content.

and some of the stuff that I see is:

1) this code:

Please Login or Register  to view this content.

might be an issue? that doesn't necessary target an entire row, does it?

https://docs.microsoft.com/en-us/dot...heet.usedrange

2) this code:

Please Login or Register  to view this content.

doesn't need the colon and equal sign I don't think. this is fine:

Please Login or Register  to view this content.

3) this code:

Please Login or Register  to view this content.

whatever RowCount1 is, I don't think would matter because you are using ''i'' to delete the indexed row. so it doesn't make sense, to me anyway, that this deletion line of code would delete only part of a row. that code would be much more complex. moreover, because it involves shifting cells up/down/left/right after deletion of a range. however, what you might not have taken into account I suppose, is that, when you delete a row, the worksheet gets rearranged and if you are using a counter in a loop and that counter is pointing to row ''x'' and you increment that counter in the next iteration but you have deleted a row at the same time, things might get a tad bit confused because the row counter is not necessarily accurate anymore unless you have made the proper adjustments.

hopefully this gives some help, aside from what dave said.

[dumdumbum]

It is not deleting the entire row if condition is matched
Plz run the macro on the sample file Sir

[vba_php]

It is not deleting the entire row if condition is matched
Plz run the macro on the sample file Sir

are you talking to everyone here?

[davesexcel]

As vba_php has mentioned, when deleting rows, it is best to start from the bottom and move up.

[dumdumbum]

Np but i need the macros Sir

[dumdumbum]

https://excelfox.com/forum/showthrea...ro-Correction)

[davesexcel]

Try this, change file location in code.

Please Login or Register  to view this content.

[dumdumbum]

Thnx Alot Davesexcel Sir for Helping me in solving this problem
Prpblem Solved
Have a Awesome Day Sir