Hi Paul,

A worksheet function returns a value to the cell contining the function. It
cannot change another cell or alter its environment.

---
Regards,
Norman



"Paul S" wrote in message
...
I have the following simplified code that represents my problem. When I
run
the code from the VBA editor, or run the individual macros it works
perfectly. But when I call Test() from a worksheet function the WriteIt
macro generates a #Value error and the EraseIt macro does nothing at all.
What am I doing wrong? Im useing Excel 2003.

Function Test() As Boolean

MsgBox ("Click OK to Write")
Call WriteIt
MsgBox ("Click OK to Erase")
Call EraseIt

End Function

Sub WriteIt()

Range("A1").Value = "Hello"

End Sub

Sub EraseIt()

Range("A1").ClearContents

End Sub