Hi Mike,
I don't see the value of i changing which is supposed to be
a row number. When you delete rows (or insert rows) it is best
to work from the bottom so you don't trip over yourself skipping
a row because you deleted the current row just before going to
the next row.

Take a look at the following and see if this helps, they don't
have the part about comparing column A and D, but since
you know about OFFSET you should not have too much of a problem.

In the #rows section of