UDF's are not allowed to change the structure of the worksheet. You'll have
to put the changes you want to make in a SUB module.

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