hi matt,

Was playing with something,

What I have is 10 ranges of information from row 4 to row 34 as follows (B4:C34) (D4:E34) and so on

What i want to do is first sort B4:C34 the D4:E34 and so on

started playing with looping across one after the other and as part of that got side tracked into how to get a column letter.

Still looking for the best method of my sorting problem but im guessing using named ranges might be best and then just looping through them

Unless your gonna (Which you probably are) tell me theres a better way

Thanks for the reply

Gibbo