Code to delete rows only works sometimes

[BartSeli]

Dear all,

I wrote the following code to copy a range of cells from one tab to another one (below a list) and delete a few rows based on the cell value of another column (and update a few pivots, hide a few rows in other tabs). The deleted rows are duplicates in the list on tab "RTC - Status en opvolging". I identify these duplicaties by using vlookup in the same range (which checks whether there is already the same ordernummer above the cells that have been pasted). If the value of this if(iserror(vlookup)-statement = 1, then the row should be deleted.

This code worked fine in the beginning, but now it seems that it does not delete the rows anymore even though the value in column K=1. Can anybody help me and point me out what's wrong with the code?

Thanks in advance,

Bart

Please Login or Register  to view this content.

[xladept]

All I can see is that you need to indicate a new line here:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[BartSeli]

In the original code the lines are placed under each other, so I don't think this correction is necessary or am I wrong? I really can't figure out why it's not working anymore..If someone is willing to have a look at the original file, I will be glad to send it over.

Thanks in advance!

[xladept]

Hi BartSeli,

I tested this code:

Please Login or Register  to view this content.

and it ran like a charm!

[BartSeli]

I can't figure it out either. Can it has something to do that the cell value of "1" is calculated in a table of excel 2010?

[xladept]

Have you single stepped through the code? I love the code by the way - did I rep you for that? - I intended to