Named Ranges in VBA - Global or not?

[Bill Hamilton]

It's amazing how the blindingly obvious can be so obscure sometimes. Yes, this works.

I thought I had tried this originally but looks like I can't have got the reference quite right. I was thinking that the problem was with the reference to the actual sort area, not the key area. I'm known for saying that if the problem isn't where you are looking, it must be somewhere else. Too right.

Many thanks.