vba 求助
求大佬看一看我这段代码哪里有问题
Sub test()
Dim date_ As String
Dim range_ As Range
Dim i As Integer
Dim range2 As Range
date_ = "201801"
Set range_ = Range(Cells(8, 1), Range("A8").End(xlDown))
Do While date_ <> "201813"
Set range2 = rowaa(range_, date_)
date_ = date_ + 1
Loop
End Sub
以下是函数
Public Function rowaa(range_ As Range, date_ As String)
For Each i In range_
If Not (i.Value Like ("*" & date_ & "*")) Then
Exit For
End If
Set rowaa = i
Next
End Function
在do while第二遍运行到Set range2 = rowaa(range_, date_)的时候他提示报错 要求对象。