Excel formula/macro

[joey1211]

Hi. I need a macro to do the following;

Column A is the area code which all address records are sorted by. When this code changes to the next area, I need to insert a row to divide it from the next area and insert *** (three stars) as a visual indication of the change.

A B C
1 abc abc
1 abc abc
1 abc abc
*** *** ***
2 abc abc

 

[joey1211]

Hi

Thanks for that. Very nearly. The code seems not to add an extra row, just inserts stars into the cell beneath

The spreadsheet is to be mail-merged and I want a sheet with *** in the address lines seperating every Selection Code (column C)

 

[joey1211]

Brilliant, thanks. Works a treat.