Then change the And to an Or and put some extra lines of code in to get your
text "CAR" and the offsets.

RBS

"5elpep" wrote in message
oups.com...
Thanks for your input RB.

Unfortunately I mis-typed my question. I meant to say how might it be
modified so that it inserts rows where the contents of
columns A OR B change?

Also I then need to change the blank row so that column C displays
"CAR", column D returns =OFFSET(D*,1,-3) and column E returns
=OFFSET(E*,1,-3).
To use a silly example:

MON 12 XKR
MON 12 FOCUS
MON 12 LAND CRUISER
TUES 13 HUMMER

Will look as below on running the code

MON 12 XKR
MON 12 FOCUS
MON 12 LAND CRUISER
CAR
TUES 13
TUES 13 HUMMER

and so on