rodneywead
04-15-2011, 03:08 PM
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
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