View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alistre alistre is offline
external usenet poster
 
Posts: 7
Default 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)