Sub sortt() ' Функция поиска двойных денежных потоков Application.ScreenUpdating = False ActiveWorkbook.Worksheets("Общая ОСВ").AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets("Общая ОСВ").AutoFilter.Sort.SortFields.Add Key:= _ Range("F5"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets("Общая ОСВ").AutoFilter.Sort .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With For i = 6 To ActiveSheet.Cells.SpecialCells(xlLastCell).Row If Range("F" & i) = Range("F" & i + 1) And Range("D" & i) Range("D" & i + 1) Then Range("B" & i & ":M" & i + 1).Select 'заменить на эту строку With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorAccent6 .TintAndShade = 0.599993896298105 .PatternTintAndShade = 0 End With i = i + 2 'b 'и это добавить Else Range("B" & i & ":M" & i).Select With Selection.Font .ColorIndex = xlAutomatic .TintAndShade = 0 End With With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 End With End If Next i ActiveWorkbook.Worksheets("Общая ОСВ").AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets("Общая ОСВ").AutoFilter.Sort.SortFields.Add Key:= _ Range("A3"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets("Общая ОСВ").AutoFilter.Sort .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With Application.ScreenUpdating = True End Sub