View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norm Norm is offline
external usenet poster
 
Posts: 71
Default Is it possible to build sort statement?

I'd like to build a macro that does a number of user-specified things to a
file. One of them is to sort. The user would specify up to 3 columns to
sort. Can an Excel macro "build" the sort parameters? The following sure
doesn't work:

s = "Key1:=Range(""A2""), Order1:=xlAscending, " & _
"Key2:=Range(""B2""), Order2:=xlAscending, "
Range("A1:H6563").Sort s

Thanks for the help!