Hi Gang,

What is the VBA statement or sequence needed to insert a blank row in
between changes in a particular column? Say I have a column that has
the alphanumeric sequence of abc123. It then repeats 5 times downward
in the same column. Then the sequence changes to def456. How do I
insert a blank row in between the changes in sequence?

Thank you as always.


Sam