簡單搜尋 ID 時出現運行時錯誤 91...為什麼? (已解決:搜尋失敗,因為單元格格式為帶逗號的數字 - 奇怪但正確,將格式更改為“常規”並且它完美運行!謝謝你們!)
Public Sub SearchID()
Dim foundCell As Range
Dim searchEmpID As String
Dim searchRange As Range
Dim rowFound As Integer
searchEmpID = "EmpID_0112"
Set searchRange = Sheets("HoursData").Range("DY2:DY999")
Sheets("HoursData").Select
Set foundCell = searchRange.Find(What:=searchEmpID, LookIn:=xlValues, LookAt:=xlWhole, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
MsgBox Sheets("HoursData").Range("DY115").Value '<<<<< 資料/ID 在那裡,請參閱螢幕截圖。
rowFound = foundCell.Row '<<<<<<<<<<<< Why this produces Runtime Error 91/Object Variable Not Set...???
End Sub