Why can't I sort these rows of data ascending???
Posted by Brian A. on April 11, 2001 5:09 PM
I'm trying to sort ascending some data from a macro.
I am selecting the entire rows based on two variables: ABCBegin and ABCEnd.
Here's the Code I am trying to use:
.Rows(ABCBegin & ":" & ABCEnd).Select
Selection.Sort Key1 = Range("A & ABCBegin"), Order1 = xlAscending
I'm trying on concatenate "A" for Column A then ABCBegin for the row number
so the macro knows what to sort by. This isn't working.
Please help if you know this!