Thanks very much for all your contributions, I have
implemented Chip's code.

Mark

-----Original Message-----
I am using Excel 97 and I have a list of surnames in
Column A of a spreadsheet.

What I am trying to achieve is to sort them into order
but
place A Capital letter in the row immediatley above when
the lfirst letter changes

For example:-

A
ADAMS
ARTHURS
ABBOTT
B
BRIGGS
BAMFORTH
BENTLEY
C
CHILDS
COLDWELL

through to Z

What I also need in the routine is an error check so that
if a letter of the alphabet does not exist it moves down
to the next letter


Can anyone assist me with some code to do this please?


Mark
.