Attached file Postcode summary.xlsx contains a list of Towns and Postcodes in Cols A and B, and shows in Cols F - H what I need to produce.

Objective:

If a Town has consecutive Postcodes, "copy and paste" the first and last values from the range onto one row for each Town.
If the postcodes are NOT consecutive, each one goes on a row of it's own.

I created a Macro that worked for US "Zip Codes" because they are purely numeric.

What is defeating me is the Code that "recognises" the alphanumeric pattern so it "sees" AL1, AL2 and AL3 as "consecutive" but AL5 as "unique"

Sure it's staring me in the face.

Any suggestions and guidance accepted gratefully

Ochimus