tvyur, конечно ваши объеденные ячейке это жесть...да еще не одинаково.
Код |
---|
Sub fdf()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
ActiveSheet.DisplayPageBreaks = False
Application.DisplayAlerts = False
Dim i As Long, n As Long, k As Long
LR = Cells(Rows.Count, 2).End(xlUp).Row
For i = 45 To LR
If Cells(i, 2) = 4 Then
For n = 29 To 209 Step 12
Cells(i, n) = "Ð"
Cells(i + 1, n) = "Ð"
Next n
ElseIf Cells(i, 2) > 4 Then
For k = 29 To 209 Step 6
If Cells(i - 5, k) <> "Ð" Then
Cells(i, k) = "Ð"
Cells(i + 1, k) = "Ð"
End If
Next k
End If
Next i
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
Application.EnableEvents = True
ActiveSheet.DisplayPageBreaks = True
Application.DisplayAlerts = True
End Sub |