Hi all,

PLEASE can you give me some help.

I've got an excel spreadsheet and i want to write a macro so that it compares my cell values and if it is equal it adds a new row.pls just look at my example then you will understand what i mean

ive got the following in col A:
1
1
1
1
2
2
2
3
3
3
4
4
Now i actually want it to look like this
1
1
1
1
NEW ROW
2
2
2
NEW ROW
3
3
3
NEWROW
4
4
NEWROW
etc

Please help!