I have read a few tutorials about sorting (in excel) with the columns merged (yes they are different sizes), so i was wondering if anyone has a possible solution to this. I have tried copying the info somewhere else, un-merging then re-merging but it doesn't seem to like it (because they are different sizes).
Here is an example of my document:

http://img93.imageshack.us/img93/8319/screeniemu0.jpg

As you can see i need to sort via 'Column G' but when i try it get the error "This operation requires the merged cells to be identically sized".

I have read that this is one of the most common problems with merged cells and have yet to find a solution that works.

Thanks

just write in quickly in vba and be done with it, would be my advice

Yea thats what im doing now, just wondering if there was a nice and simple way (or will you tell me that after i've spent ages writing it - as usual )

What is the correct vba to select the next 8 columns ?

Range(Selection, Selection.End(xlToRight)).Select
(8 times)

doesn't seem to work