If your invoice number is in C9, then you are comparing it with that in C8

i=9
if range("C" & i)<range("C" & i-1) then rows(i).insert

"A" wrote:

any way to say 'insert a line' if a parameter meets a certain condition?

In my case, I want to insert a line it the invoice number doesn't match the
invoice number above it.

Thx,

A