View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GB[_3_] GB[_3_] is offline
external usenet poster
 
Posts: 70
Default Passing array to a function

AAA=ExactMatch ( Guess(1,) )

The above does not work, needless to say.

ExactMatch is a function expecting to receive a single dimensional array

Guess is a 2-dimensional array. What I am attempting to do is pass the 1st
row of Guess to the function.

What is the correct syntax to do that, please? (Obviously, I can be more
explicit about what I am passing across, but I thought VBA would take care
of this for me.)

Thanks

Geoff