VBA excel sorting based on 3 column criteria

[welchs101]

Hi,

I used the "record macro" to find out how to sort my data but it gives a lot of stuff. Not 100% sur what is needed and what is not.

I have data in A1: Z300. Row 1 (ie...A1:Z1) is headers.

I want to sort the data set
By A1
By X1
By Z1

Any ideas on how to do this via VBA? I dont want to do 3 separate sorts.......i assume there is a way to do one sort with all 3 criteria at once.

[welchs101]

if i have to do 3 sorts that fine........

[welchs101]

i think i may have figured it out..........

Please Login or Register  to view this content.

it seems to work.

[snb]

or

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[welchs101]

snb,

i like yours better than mine....less typing. thanks!!!!!!!

learned something new again.