The archives want to see your final answer

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Russell Dawson" wrote in message
...
Many thanks for the answers.


--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Russell Dawson" wrote:

In a column of periodically changing names in alphabetical order (col
A) €“ I
need to insert a row after each change in initial letter. So when the
names
have been sorted when the initial letter of the name changes from A to B
as
in Aldred to Bute there is a blank row inserted after Aldred.

It would be nice if the code could include the instruction to sort the
names
first rather than that being a separate action. Sort by column A to
include
other related data in columns to F.

Thanks
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.