我将尝试在列表中查找一个ID并获取其地址,但如果没有找到,则需要处理这种情况。
以下是我的代码:
当我运行
以下是我的代码:
Function find_in_two_ranges_two_sheets(ws1 As String, col1 As Integer) As Range
Dim rows1 As Integer
rows1 = Get_Rows_Generic(ws1, 1)
Dim range1 As Range ' range of first search
With Worksheets(ws1)
Set range1 = .Range(.Cells(1, col1), .Cells(rows1, col1))
End With
Dim found1 As Range
Set found1 = range1.Find("test id", LookIn:=xlValues)
If found1 = Nothing Then
MsgBox "nothing"
Else
MsgBox found1.AddressLocal
End If
Set find_in_two_ranges_two_sheets = range1
End Function
Sub test_stuff()
Dim x As Range
Set x = find_in_two_ranges_two_sheets("usersFullOutput.csv", 1)
MsgBox x.Address
End Sub
当我运行
test_stuff()
函数时,在第 If found1 = Nothing Then
行出现了一个错误,单词 Nothing
被突出显示。错误信息是“编译错误; 对象无效”。不确定该怎么办。