R
Reems
I have a problem that has stumped me and I was hoping someone could hel
me out. I have data in rows 2 through 15 with a header row and the
blank rows until row 51. After I sort the data, I am getting duplicat
entries for the data that was oirginally in rows 2 through 15, but th
data that was orignially in rows 51 through 500 is fine. Only a coupl
get duplicated, not all of them. Here is my code....
Cells.Select
Selection.Sort Key1:=Range("A2"), Order1:=xlAscending,
Key2:=Range("B2") _ , Order2:=xlAscending, Header:=xlGuess
OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom
Range("A1").Select
Thanks for the help
me out. I have data in rows 2 through 15 with a header row and the
blank rows until row 51. After I sort the data, I am getting duplicat
entries for the data that was oirginally in rows 2 through 15, but th
data that was orignially in rows 51 through 500 is fine. Only a coupl
get duplicated, not all of them. Here is my code....
Cells.Select
Selection.Sort Key1:=Range("A2"), Order1:=xlAscending,
Key2:=Range("B2") _ , Order2:=xlAscending, Header:=xlGuess
OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom
Range("A1").Select
Thanks for the help