P
Phrank
I have the following sort macro:
Cells.Select
Selection.Sort Key1:=Range("L2"), Order1:=xlAscending,
Header:=xlYes
Range("A1").Select
This works just fine, but I may have occasion to add , remove, or move
a column. Is there a way to have it sort on a named range? This
would allow for the columns to change but still sort on the given
column without having to go back into the macro and change the Range.
I tried naming a column and having it sort that way, but I was given a
debug error (as below). Thanks for any help.
Cells.Select
Selection.Sort Key1:=Range(Name), Order1:=xlAscending,
Header:=xlYes
Range("A1").Select
Cells.Select
Selection.Sort Key1:=Range("L2"), Order1:=xlAscending,
Header:=xlYes
Range("A1").Select
This works just fine, but I may have occasion to add , remove, or move
a column. Is there a way to have it sort on a named range? This
would allow for the columns to change but still sort on the given
column without having to go back into the macro and change the Range.
I tried naming a column and having it sort that way, but I was given a
debug error (as below). Thanks for any help.
Cells.Select
Selection.Sort Key1:=Range(Name), Order1:=xlAscending,
Header:=xlYes
Range("A1").Select