Hi Nacho.

a UDF returns a value it cannot change another cell.

---
Regards,
Norman



"Nacho Nachev" wrote in message
...
Hello,

I have some problem with a VBA function that I use within a formula. What
is
special about my function is that it also should modify particular cell in
the current spreadsheet. However it does not work. My fragment of code
dealing with this is he

Application.ActiveSheet.Cells(49, 3) = 10

I have also tried other approaches but with no luck. Neither the
spreadsheet, nor the cell are protected.

Is there any workaround for this problem?

Thank you for your time,
Nacho