Hi all,
I'm using a (probably very ugly) macro to sort columns in a worksheet, and I keep getting an error when it gets to column AQ. Has anyone else ever run into this? Is it a sort limit? Here's the line that's getting the error:
ActiveWorkbook.Worksheets("Sheet6").Sort.SortFields.Add _ Key:=Range("AQ:AQ"), SortOn:=xlSortOnValues, Order:=xlAscending, _ DataOption:=xlSortNormal
Thanks for looking!
~Kb
I'm using a (probably very ugly) macro to sort columns in a worksheet, and I keep getting an error when it gets to column AQ. Has anyone else ever run into this? Is it a sort limit? Here's the line that's getting the error:
ActiveWorkbook.Worksheets("Sheet6").Sort.SortFields.Add _ Key:=Range("AQ:AQ"), SortOn:=xlSortOnValues, Order:=xlAscending, _ DataOption:=xlSortNormal
Thanks for looking!
~Kb