请教Range.Find寻找日期是要注意些甚么?资料就在,但是,Find就是找不到?不知是格式的问题还是其他?请教大家!
For i = 0 To 20 \'一般年假应该不超过7天20210909改为12天20210923改为20天
StartDate = DateAdd("d", i, StartDate)
StartDate = Format(StartDate, "yyyy-mm-dd")
Set Price_StartDate = .Range("A2").Resize(1, Price_LastRow).Find(what:=StartDate, LookIn:=xlFormulas, SearchOrder:=xlByRows)
If Not Price_StartDate Is Nothing Then
Price_StartRow = Price_StartDate.Row
Exit For
End If
Next i