On Thu, 7 Feb 2008 10:28:52 -0800 (PST), snv wrote:

I am trying to enter my own function in an array formula context,
similar to any other pre defined funtion.

Take a look here for some information:

http://www.cpearson.com/excel/return...ysfromvba.aspx

What you need to do is test your argument(s) to see if they are arrays or not;
and if they are, you need to set up an array within your code; and then equate
it to the function name.
--ron