"Stuart" wrote in message
...

Q1: Why has the Collection failed to build please?

Is it failing because it exits because LastRow = 2? The code you posted has
a runtime error, an End If without an If


Q2: How can I sort a Collection alphabetically please?


Check out http://j-walk.com/ss/excel/tips/tip47.htm