|
Sub tt1()
r = [A65536].End(3).Row
If Cells(r, "a").MergeCells Then
rr = r + Cells(r, "a").MergeArea.Rows.Count - 1
Else
rr = r
End If
'---------------------------------
Set A = Range("A4:A" & rr)
For i = 1 To A.Cells.Count
With A.Cells(i)
If .MergeCells And Len(.Value) > 0 Then
X = .MergeArea.Address
Set S = Range(X)
For j = 1 To S.Cells.Count
With S.Cells(j)
Select Case j
Case 1
.Offset(, 3).FormulaR1C1 = "=IF(MAX(RC[5]:RC[6])-MIN(RC[5]:RC[6])>6,MAX(RC[5]:RC[6]),MIN(RC[5]:RC[6]))"
Case 2
.Offset(, 3).FormulaR1C1 = "=IF(MAX(R[-1]C[6]:R[-1]C[7])-MIN(R[-1]C[6]:R[-1]C[7])>6,MAX(R[-1]C[6]:R[-1]C[7]),MIN(R[-1]C[6]:R[-1]C[7]))"
Case 3
.Offset(, 3).FormulaR1C1 = "=IF(MAX(R[-2]C[7]:R[-2]C[8])-MIN(R[-2]C[7]:R[-2]C[8])>6,MAX(R[-2]C[7]:R[-2]C[8]),MIN(R[-2]C[7]:R[-2]C[8]))"
Case 4
.Offset(, 3).FormulaR1C1 = "=IF(MAX(R[-3]C[8],R[-3]C[5])-MIN(R[-3]C[8],R[-3]C[5])>6,MAX(R[-3]C[8],R[-3]C[5]),MIN(R[-3]C[8],R[-3]C[5]))"
End Select
End With
Next
i = i + 3
Else
.Offset(, 3).FormulaR1C1 = "=Min(RC[5]:RC[8])"
End If
End With
Next
End Sub |
评分
-
1
查看全部评分
-
|