I wrote this function[vba]Function Test(r as Range)R(1,1).Font.Color=VbRedEnd Function[/vba]Now when I call this function in a cell Formula[vba]=Test(A1:C3)[/vba]Nothing changed, like the cell is in lock to changes, but when I call the function from UserForm its work.Any ideaThanks