Below is my snippet of code. When I run the routine it doesn't match the entire cell contents, it will find partial matches. You'll also notice in the code that some of the parameters (including LookAt) did not auto-capitalize. I'm not getting an error message, but the Find method just isn't working the way I'm needing any to. Any advice?

Set rFound = .Columns(2).Find(What:=Me.CourseText.Value, After:=.Cells(1, 2), LookIn:= _
    xlValues, lookat:=xlWhole, searchorder:=xlByRows, searchdirection:=xlNext, MatchCase:= _
    False, searchformat:=False)