Čaute!
Menší problem v zoradení skupín.
Mám 8 skupín a každú skupinu mi zoradí ako má okrem tej siedmej skupiny. Pritom kódy sú rovnaké neviem najsť chybu. Tu sú tie kódy:
Private Sub Worksheet_Activate()
ActiveSheet.Unprotect
Sheets("Hárok14").Select
Range("B5:G8").Select
Selection.Sort Key1:=Range("G5"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Sheets("Hárok14").Select
Range("B11:G14").Select
Selection.Sort Key1:=Range("G11"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Sheets("Hárok14").Select
Range("B17:G20").Select
Selection.Sort Key1:=Range("G17"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Sheets("Hárok14").Select
Range("B23:G26").Select
Selection.Sort Key1:=Range("G23"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Sheets("Hárok14").Select
Range("J5:O8").Select
Selection.Sort Key1:=Range("O5"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Sheets("Hárok14").Select
Range("J11:O14").Select
Selection.Sort Key1:=Range("O11"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Sheets("Hárok14").Select
Range("J17:O20").Select
Selection.Sort Key1:=Range("O17"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Sheets("Hárok14").Select
Range("J23:O26").Select
Selection.Sort Key1:=Range("O23"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub
Ten červený kód mi nefunguje ale v skutočnosti je všetko to isté. Vie mi to niekto zistiť, aký je vtom problem? Ďakujem!!!