xlascending

[excel_lover]

Hi All,

I have a problem with getting my code to sort ascending.
Here is the code i have used -

Please Login or Register  to view this content.

If I delete the Order1:=xlAscending it does the sort but orders descending!
can anyone tell me what im doing wrong?

Thanks

[Andy Pope]

The the use of 2 different worksheet names deliberate?

[excel_lover]

Thanks Andy
Easy to overlook! now ive altered it it works

[martindwilson]

i see you are applying this to your postcode problem which i posted and you never acknowledged. sample i posted sorts without resorting to macro.