Sub 正向()
arr = Range("e1:e" & [e65536].End(3).Row)
For i = 1 To UBound(arr)
x = arr(i, 1)
For m = 1 To Len(x)
xstr = xstr & Mid(x, m, 1)
Next
Next
'xstr = StrReverse(xstr) '加此句则为反向(字符串反转)
Set d = CreateObject("scripting.dictionary")
brr = Range("f1:f" & [f65536].End(3).Row + 1)
For i = 1 To UBound(brr)
If Len(brr(i, 1)) > 0 Then d(brr(i, 1)) = ""
Next
ReDim crr(1 To 1000, 1 To 1)
For n = 0 To 999
p = (n + 1) Mod Len(xstr)
If p = 0 Then p = Len(xstr)
myF = Val(Mid(xstr, p, 1))
If d.exists(myF) Then
k = k + 1
crr(k, 1) = n
End If
Next
[H:H].Clear
If k > 0 Then [H1].Resize(k) = crr
[H1].Resize(k).NumberFormatLocal = "000"
End Sub