Hi Guy's,
Can anyone assist in explaining the below code. I want to understand the bold section and how it works. Any help us much appreciated.
With Sheets("Analyst Codes").Range("A:A")
Set Rng = .Find(What:=FindString, _
After:=.Cells(.Cells.Count), _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
If Not Rng Is Nothing Then
Find_Analyst = True
Else
Find_Analyst = False
End If
End With
Can anyone assist in explaining the below code. I want to understand the bold section and how it works. Any help us much appreciated.
With Sheets("Analyst Codes").Range("A:A")
Set Rng = .Find(What:=FindString, _
After:=.Cells(.Cells.Count), _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
If Not Rng Is Nothing Then
Find_Analyst = True
Else
Find_Analyst = False
End If
End With