Passing optional parameters to Excel functions

[Shankar_R]

For the native Find function, all parameters except the 'What' value are optional.

For example,
MatchCell = Range1.Find("Hello")
MatchCell = Range1.Find("Hello", MatchCase:=True)