Worksheet Functions
I am trying to codify Excel's Match function in VBA. Somewhere I have
a syntax error. I cannot figure it out. I am just learning about the
"Application.WorksheetFunction" syntax. Can you help me with writing
the Match argument?
Range("A10") =
Application.WorksheetFunction.Match(Range("L8").Te xt,Range("A1:A550"),0)
|