I believe i have it sorted now. The problem seemed to occur when i tried to
assign the macro to a button. So i assigned it to an image, and presto!!!!
Big thanks for all your help. :))

Matt

"SteveW" wrote:

Not much wrong with that as far as I can see.

Looks like my test one

When mine runs it leaves the sort area selected.

What happens with yours ?
Click on say C5, then run the macro
It should leave A:B selected

Steve