Using VBA in a macro, I want to insert a new row everytime the data changes
in the rows of column A. Example
A1=Chevy
A2=Chevy
A3=Dodge
A4=Dodge.

A new row would be inserted between Chevy and Dodge when I run the macro.
Any help would be appreciate, thanks inadvance.