|
VBA不同字母代表不同数字
引用2楼成果,暴力搜索。 - Sub tt()
- ' s e v e n
- '+ t h r e e
- '+ t w o
- '____________
- 't w e l v e
- '===>> t=1:w=0:s=8 or 9:h=0 or 9:n+o=10
- [a:a] = ""
- t = 1: w = 0
- For s = 8 To 9
- For e = 0 To 9
- For v = 0 To 9
- For n = 1 To 9
- x1 = Val(s & e & v & e & n)
- o = 10 - n
- For h = 0 To 9 Step 9
- For r = 0 To 9
- x2 = Val(t & h & r & e & e)
- x3 = Val(t & w & o)
- ss = CStr(x1 + x2 + x3)
- l = Mid(ss, 4, 1)
- If Chk(t & h & r & e & s & n & w & o & l & v) Then
- If ss = t & w & e & l & v & e Then
- pp = pp + 1
- Cells(pp, 1) = x1 & "+" & x2 & "+" & x3 & "=" & ss
- End If
- End If
- Next: Next: Next: Next: Next: Next
- End Sub
- Function Chk(s) As Boolean
- Dim i%
- 'If InStr(s, "0") Then Exit Function
- For i = 1 To Len(s) - 1
- If InStr(i + 1, s, Mid(s, i, 1)) Then Exit Function
- Next
- Chk = True
- End Function
复制代码
|
|