A function called from a worksheet cell cannot make any changes
to the Excel environment, including change the value of another
cell. It can only return a value to the which called it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


wrote in message
oups.com...
I made a UDF (so residing in a function module) and want to
change the
value of a cell on "sheet1" but this doesn't work. I can read
the value
but not set it. Like it was read-only. It doesn't seem to work
with
other properties (e.g. colour) to

Regards
Benny