Sending data back to parameters
"Patrick" wrote in message
...
Hi every1!!!
Need to know if this can be done. Here is my problem.
Ive created a custum function that takes-in parameters from a few cells on
same row
its being called from.
With those parameters i do some calculations and find what needs to be
found.
So far so good.
Lets say i find the following answer inside this function of mine: 45
Could i then redirect that answer to one of my parameter cell.
Senario:
Columns
L M N AF
0 0 0 (my function is here)
Lets say my funct. says that when L,M,N =0 then M should equal to : 4
Can i asign that 4 to M while still in my function.
Can this be done?
Thx for your help
PAtrick
Not from within a cell function. You should use the Worksheet_Change event
to do this.
/Fredrik
|