点击文件名下载附件
可否查找有顺序数据的个数
Sub Numtype() Dim dic As Object, i&, R As Range Set dic = CreateObject("scripting.dictionary")
With Sheet1 For Each R In .Range(.Range("A5"), .Range("A65536").End(xlUp)) If Not dic.EXISTS(R) Then dic.Add R.Value, "" End If Next For i = Application.Min(dic.KEYS) To Application.Max(dic.KEYS) If dic.EXISTS(i) Then dic.Remove i Else dic.Add i, Nothing End If Next .Range("C2:C500").ClearContents .Range(.Cells(2, "C"), .Cells(dic.Count + 1, "C")) = Application.Transpose(dic.KEYS) End With