#Value! error when using ActiveCell.Interior.Color

[Matt]

I have a function;

Function MyColor()
ActiveCell.Interior.Color = RGB(255, 0, 0)
End Function

When a call the function from a cell [=myColor()] it returns a #Value!
error. and does not changed the color. If I then click 'show calculation
steps' the color changes but the error remains.

This seems to be happening for any function that tries to modify the cell
properties . I am using Excel 2007.

 

[Bob Phillips]

You cannot change a cell from within a function called from a worksheet.


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)