Hello,

Hope You can help me.

Am just taking first tentative steps into macros and VBA. Finding most of my info from sites like this so thanks for that.

I am struggling with something recently though and don't seem to be able to find a way to do what I want. It'll probably be really simple though...

If I have a list of values in column A which are sorted from low to high but there are different counts of each value....

eg

1
1
1
2
2
3
4
4
4
4
5
6
6



.....and I want to select ranges in column B like this ... "Range("B1:B3,B4:B5,B6,B7:B10,B11,B12:B13").Select" where each range represents a value in column A how would I do that?

The values in column A are not always the same but they are always sorted as mentioned above.

I am aiming to merge the cells in Column B based on the values in column A as per the attached Book6.xlsx

Thanks in advance