Deleting a row by cell value

[mellowtang]

Hello,

I have this piece of code that should delete an entire row according to some cell value.

Please Login or Register  to view this content.

The code just goes through and does nothing any help would be appreciated.

[LJMetzger]

Hi mellowtang,

I haven't tested the code, but the following line is probably wrong:

Please Login or Register  to view this content.

You probably want something like:

Please Login or Register  to view this content.

Lewis

[mellowtang]

Hey,

Thanks for your reply. I tried your suggestion but it doesn't do the trick

mellow

[apo]

Can you attach a sample workbook..

What you want to do can be achieved in a number of ways..

btw.. how many rows would you typically be working with?

[mellowtang]

Thanks for the reply

I attach the sample workbook with the code that I have by now.

1. The empty row between the data separates the old data (upper portion) and the new data (lower portion).
2. Each day I add up to a 100 lines of new data from which I have to delete rows with "NULL" value in column I. This is where the macro comes in.
3. Then I do some analysis, some other manipulation, delete the empty row and go to make myself a cup of coffee.

Best,

mellow

testbook.xlsm

[apo]

Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

You were offsetting to the wrong column...

In the future.. to debug.. either use the "Watch Window" in the VBEditor.. in this case adding a watch for "Entry.Offset(, 9)" and step through the code (F8).

Another way is to just hover your cursor over the code as you step through it to see the value.

Either of these would have shown you that you were offsetting 1 column to far over.

[mellowtang]

Damn... I'm such a newb

Thanks a lot!

[apo]

No worries.. you're welcome.. thanks for the Rep.