I am not sure what it is you are trying to do. Dave gave you VBA code that
showed how to assign a value to a cell. Maybe if you could explain what you
want to do, someone could come up with something.

"magix" wrote:

Dave mentioned that "A function called from a cell on a worksheet can't
change the value in
another cell."

Could anyone tell me if there is any workaround to set a value in another
cell with a function called from a cell.

Thanks.
Regards.