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.

<bve@spe.be> wrote in message
news:1129643359.488025.256470@g47g2000cwa.googlegroups.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
>