|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Private Function solve(a, b)
Dim ret(0 To 9)
For i = 0 To 9
ret(i) = countDigit(b, i) - countDigit(a - 1, i)
Next
solve = ret
End Function
Private Function countDigit(n, x)
ret = 0: vbase = 1
Do While vbase <= n
a = n \ vbase
b = n Mod vbase
c = a Mod 10
a = a \ 10
If c > x Then
ret = ret + (a + IIf(x = 0, 0, 1)) * vbase
ElseIf c = x Then
ret = ret + (a - IIf(x = 0, 1, 0)) * vbase + (b + 1)
Else
ret = ret + a * vbase
End If
vbase = vbase * 10
Loop
countDigit = ret
End Function
Public Sub main()
a = 1: b = 100004000
ret = solve(a, b)
End Sub
|
评分
-
2
查看全部评分
-
|