Probably you need a UDF returning a FormulaArray. Check the following
link:

http://www.developersdex.com/vb/mess...2677&r=5859124


Mangesh


On Aug 8, 3:28 pm, wrote:
I want to create a User Defined Function which runs other procedues to
populate an array of cells. i.e.

User inputs "=GetMyData(arg1, arg2, arg3 ...)" into cell A1

Cells A3 to Bn is populated with relevant data.

Any pointers would be greatly appreciated.

Toy.