I have an required date in colmn E and a confirmed delivery date in column H.

I need code to delete the line if colmn E date is before Colmn H date. This
needs to run through a worksheet that varies in size daily.

All help very much appreciated.

"minimoi" wrote:

I have an required date in colmn E and a confirmed delivery date in column H.

I need code to delete the line if colmn E date is before Colmn H date. This
needs to run through a worksheet that varies in size daily.

All help very much appreciated.

Forgot to mention that if the date in colmn H, has it's cell highlighted in
red then I do not want it deleted.