Hello,

A function is different than a procedure, they are not the same, and that is
what you asked for. If you want to know how to *use* the function using
VBA, well, why don't you use it just the way it is, using the Evaluate
method?

Evaluate("=INDEX([VBPA.xls]Sheet1!$D$1:$D$50000,MATCH(1,(INT(D3)=[VBPA.xls]Sheet1!$A$1:$A$50000)*(""BP""=[VBPA.xls]Sheet1!$C$1:$C$50000),0))")

(did not test your formula) Just be sure and use double quotes around your
text in the formula, single quotes will skew it in VBA.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"Jeff" wrote in message
...
Hello,


I need ASAP to transform this function into a VBA macro to finish an
existing VBA Macro

=INDEX([VBPA.xls]Sheet1!$D$1:$D$50000,
MATCH(1,(INT(D3)=[VBPA.xls]Sheet1!$A$1:$A$50000)*("BP"=[VBPA.xls]Sheet1!$C$1:$C$50000),0))
--
Regards,
Jeff