Code selects first and last rows with consecutive values and with unique values

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

skywriter,

Apologies for delay in replying, but had to pop into hospital shortly after I posted the query last week.

You are quite right. In the attachment I sent the first bloc should have been AL1 - AL4, then AL6 as a "unique" before moving on to the next town.

But sadly I'm no nearer working out how to achieve it either way!

Ochimus