View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joes joes is offline
external usenet poster
 
Posts: 4
Default How to use MATCH with a vector in VBA?

Hello

I like to call the worksheetfunction MATCH in VBA. I am using the
formula
=MATCH(2;1/(2:2<"")) for getting the last used column. How do I
programm that with VBA?

Application.WorksheetFunction.Match( ... ???? )

Thanks for any hints and examples

regards
Mark