Hi every1!!!

I know that if you create a custum function you can return avalue and take
in some parameters as well. So far i have no problems with this.

My problem is could i return more then one value, and not to the same cell,
that this function is being called from.

Example:
This function i need is used on X number or rows. (1000 so far)
Maybe all the rows will have data and maybe not,its dynamic.

So,lets say we figure this out on the data entered on line 1.

This function is called from column D1, and it takes in parameters A1 & B1.

It does a few calculations, and returns the result to calling cell D1,let
say it returns 34.

so it looks like this now:

A1 B1 C1 D1
30 4 -- 34
Could i also return another value from that function to cell C1 for example
something like 17.

so it looks like this:
A1 B1 C1 D1
30 4 17 34

and so one for the next rows that have values, the same thing would be done
as well.(dynamiclly, as needed)

If this is possible how would you do this from VBa, and if its not, is there
a way to do-it anyways.

Please let me know, i just cant figure-out how to copy data into another
cell from a dynamic custum function...

Any help or suggestion will be very much appreciated.
thx again,
PAtrick