VBA Function
 

I have a main program in VBA and it calls another program=Blend several times.

"Blend" depends on two array inputs that change in the Main program.

Is there anyway to specify the inputs when I "Call Blend"

like "Call Blend(x,y)" where I set x=Array1 and y=Array2 ?

Thanks

Yes, but your sub has to use them

Sub Blend(ary1, ary2)

'do something with ary1 and ary2

End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeff" wrote in message
...
I have a main program in VBA and it calls another program=Blend several
times.

"Blend" depends on two array inputs that change in the Main program.

Is there anyway to specify the inputs when I "Call Blend"

like "Call Blend(x,y)" where I set x=Array1 and y=Array2 ?

Thanks