I am using excel 2007. I am trying to call a function from a worksheet formula. This is an example from a book, but I cannot get it to work. Here is my code

Sub CallerSub()
MsgBox CubeRoot()
End Sub
Function CubeRoot(number)
CubeRoot = number ^ (1 / 3)
End Function


I am trying to call the function by typing in a cell =CubeRoot(1728). The error I get says "Ambiguous Name Detected: Cube Root"

What did I do wrong?

Thanks,

Rodney