Hi There
I guess I am just having an off day.
I have a dynamic Range in Excel ("ExamFees")
However, i now want to have code that tries to find the value of the combobox against the dynamic Range
Code
Dim r As Excel.Range
Set r = Sheets("Validate").Range("ExamFees").Find(what:=ComboBox1.Value, lookat:=xlWhole)
If Not r Is Nothing Then '//Was found
r.Select
Exit Sub
Else
MsgBox "Not found"
Exit Sub
End If
However even if the I know the combobox matches something of the dynamic Named range, it still only get the msgbox, and does not select "r".
I have thought about a do while, but not sure how I would write that.
No doubt a genius on here will solve my problem.
Thanks