...using the LOG10() function and the FIXED() function and I get an
error for both of these functions

Sub Demo()
Debug.Print WorksheetFunction.Log10(100)
Debug.Print WorksheetFunction.Fixed(1 / 7, 2)
' or...
With WorksheetFunction
Debug.Print .Log10(100)
Debug.Print .Fixed(1 / 7, 2)
End With
End Sub

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"CH" wrote in message
...
I occasionally mke user-defined functions in VBA. I am trying to write a
function using the LOG10() function and the FIXED() function and I get an
error for both of these functions - - unlike when I use other canned
functions. Are there limitations to the functions I can use in a
user-defined function? LOG() works, so I can work around the LOG10()
function.