Sort 540 individual row ranges from first to last

[jokris]

B5:B34 to S5:S34 for example contains 18 ranges, one for each column, from row 5 to 34.
Columns T, AM, BF and BY are empty.

In total there are:
* 90 ranges from row 5 to 34
* 90 ranges from row 38 to 67
* 90 ranges from row 71 to 100
* 90 ranges from row 105 to 134
* 90 ranges from row 138 to 167
* 90 ranges from row 171 to 200


B5:B34 to S5:S34
U5:U34 to AL5:AL34
AN5:AN34 to BE5:BE34
BG5:BG34 to BX5:BX34
BZ5:BZ34 to CQ5:CQ34

B38:B67 to S38:S67
U38:U67 to AL38:AL67
AN38:AN67 to BE38:BE67
BG38:BG67 to BX38:BX67
BZ38:BZ67 to CQ38:CQ67

B71:B100 to S71:S100
U71:U100 to AL71:AL100
AN71:AN100 to BE71:BE100
BG71:BG100 to BX71:BX100
BZ71:BZ100 to CQ71:CQ100

B105:B134 to S105:S134
U105:U134 to AL105:AL134
AN105:AN134 to BE105:BE134
BG105:BG134 to BX105:BX134
BZ105:BZ134 to CQ105:CQ134

B138:B167 to S138:S167
U138:U167 to AL138:AL167
AN138:AN167 to BE138:BE167
BG138:BG167 to BX138:BX167
BZ138:BZ167 to CQ138:CQ167

B171:B200 to S171:S200
U171:U200 to AL171:AL200
AN171:AN200 to BE171:BE200
BG171:BG200 to BX171:BX200
BZ171:BZ200 to CQ171:CQ200

Tried to make a macro sorting each range from first to last letter but it was too big. Thinking that perhaps I would need a loop for this procedure.

Is it possible make a macro:

1) loop and sort 18 column ranges from row 5 to 34, starting with column B
2) skip one column (T)
3) loop through each of next 18 ranges from row 5 to 34
4) skip one column (AM) etc, also skipping column BF and BY

And then continue the same procedure for row:
* 38 to 67
* 71 to 100
* 105 to 134
* 138 to 167
* 171 to 200

?

[shg]

Perhaps you could post a workbook with an example of what you have and your desired results.

[jokris]

Perhaps you could post a workbook with an example of what you have and your desired results.

Yes, attached workbook to first mail now.

[shg]

Please Login or Register  to view this content.

[jokris]

Incredible!
Can't thank you enough!

[shg]

You're welcome.