Darren Smith
Well-known Member
- Joined
- Nov 23, 2020
- Messages
- 631
- Office Version
- 2019
- Platform
- Windows
Please can someone say why this myFindRng goes red in the code?
VBA Code:
Private Sub Model_Chose_Change()
With ThisWorkbook.Worksheets("Job Card Master")
Me.Quote_Details.ListIndex = Me.Model_Chose.ListIndex
myValToFind = Make_Chose.Value
Set mySearchRng = .Columns("A")
End With
Set myFindRng = mySearchRng.Find(What:=myValToFind, _
LookIn:=xlFormulas, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False)
Last edited: