If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with duplicate entries after sorting
I have a problem that has stumped me and I was hoping someone could help
me out. I have data in rows 2 through 15 with a header row and then blank rows until row 51. After I sort the data, I am getting duplicate entries for the data that was oirginally in rows 2 through 15, but the data that was orignially in rows 51 through 500 is fine. Only a couple 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. --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Problem with duplicate entries after sorting
|
Thread Tools | |
Display Modes | |
|
|