請教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