Sub bb() Dim d, arr, i, j, k, n
arr = [a1:a10]
''''''''''''''''''''''''''''''''''''''''''''''''''' Set d = CreateObject("scripting.dictionary") For i = 1 To
UBound(arr) - 1 For j = i To
UBound(arr) - 1
k = k + 1 '循环次数计数 d(arr(i, 1)) = arr(i, 1) '加入字典 If d.Count > 1 Then '出现不同的值了 n = n + 1 d.RemoveAll Exit
For End
If Next j Next i '''''''''''''''''''''''''''''''''''''''''''''''''''
MsgBox "连续数的数量:" & n & Chr(10) & "循环次数:" & k End
Sub
循环了29次,不好; 方法太麻烦,不好, 再想,等待学习高手方法 .... 谢谢! |