技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 2244
|
9#
發(fā)表于 2008-6-9 14:06:49
|
只看該作者
這樣可以嗎?數(shù)值區(qū)域在A6:O50
Sub quweishuzi()
For X1 = 1 To 15
For Y1 = 6 To 50
a = Cells(Y1, X1)
For X2 = 1 To 15
For Y2 = 6 To 50
b = Cells(Y2, X2)
For X3 = 1 To 15
For Y3 = 6 To 50
c = Cells(Y3, X3)
If a + b + c = 254 Then
MsgBox "第一個(gè)數(shù)" & a & "地址在" & Chr(64 + X1) & Y1 & Chr(13) _
& "第二個(gè)數(shù)" & b & "地址在" & Chr(64 + X2) & Y2 & Chr(13) _
& "第三個(gè)數(shù)" & c & "地址在" & Chr(64 + X3) & Y3 & Chr(13)
Exit Sub
End If
Next
Next
Next
Next
Next
Next
End Sub |
評(píng)分
-
查看全部評(píng)分
|