Sorting on over 100 columns in Excel

[groovygarden]

I'm back, and I'm stuck (again)

I need to sort a lot of data in Excel. I could potentially have about 180 columns and 500 plus rows.

I need sort A3 to IG500, using column F to column IG as Keys (rows 1 and 2 are Headers). How can I do this without having to write Key1:= ... Key2:= ... Key167:=... etc


Very grateful for any help

 

[taupirho]

Key1:=Range("A3,IG500") for example

 

[SkipVought]

Did you try turning on your macro recorder and sorting?

Skip,
[sub]
[red][/red]
[/sub]