|
1 1 1
1 1 1 1
1 1 1 1
1 1 1
输出来是14个正方形。
- Sub test()
- arr = [a1:e4]
- m = UBound(arr)
- n = UBound(arr, 2)
- ReDim ar(m + n, n + m)
- For i = 1 To m
- For j = 1 To n
- ar(i, j) = arr(i, j)
- Next
- Next
-
- For i1 = 1 To m
- For j1 = 1 To n
- If ar(i1, j1) Then
- For i2 = i1 + 1 To m
- For j2 = 1 To j1
- If ar(i2, j2) Then
-
- If j1 = j2 Then
- If ar(i1, j1 + i2 - i1) Then
- If ar(i2, j2 + i2 - i1) Then
- k = k + 1
- Cells(k, 10) = i1 & "," & j1 & ";" & i2 & "," & j2 & ";" & i1 & "," & j1 + i2 - i1 & ";" & i2 & "," & j2 + i2 - i1
- ' Cells(i1, j1).Interior.ColorIndex = 5
- ' Cells(i2, j2).Interior.ColorIndex = 5
- ' Cells(i1, j1 + i2 - i1).Interior.ColorIndex = 5
- ' Cells(i2, j2 + i2 - i1).Interior.ColorIndex = 5
- ' [a1:e4].Interior.ColorIndex = 0
- End If
- End If
- Else
- If ar(i1 + j1 - j2, j1 + i2 - i1) Then
- If ar(i2 + j1 - j2, j2 + i2 - i1) Then
- k = k + 1
- Cells(k, 10) = i1 & "," & j1 & ";" & i2 & "," & j2 & ";" & i1 + j1 - j2 & "," & j1 + i2 - i1 & ";" & i2 + j1 - j2 & "," & j2 + i2 - i1
- ' Cells(i1, j1).Interior.ColorIndex = 5
- ' Cells(i2, j2).Interior.ColorIndex = 5
- ' Cells(i1 + j1 - j2, j1 + i2 - i1).Interior.ColorIndex = 5
- ' Cells(i2 + j1 - j2, j2 + i2 - i1).Interior.ColorIndex = 5
- ' [a1:e4].Interior.ColorIndex = 0
- End If
- End If
- End If
-
- End If
- Next
- Next
- End If
- Next
- Next
- MsgBox k
- End Sub
复制代码 |
评分
-
查看全部评分
|