Array functions can't be used in VBA. You have to pass them as you would
write them in the cell to the evaluate function. The evaluate function
would then return the result.

--
Regards,
Tom Ogilvy

"cirrus" wrote in message
...
To enter an array function directly in a spreadsheet you use
Ctrl-Shift-Enter. Obviously, you can't do that when writing VB code. Are
array functions accessible from VB. I am trying to use an array function
using MATCH and IF to look up a row based on two parameters in different
columns.