Pi in VBA?
Set a variable and use the variable
PI = Application.WorksheetFunction.Pi()
C = 2*PI*R
--
Steve
"Prof Wonmug" wrote in message
...
What's the best way to get the most accurate value for pi in a VBA
function?
Excel 2007 has a pi() worksheet function, but there doesn't appear to
be a corresponding VBA function. The best I could come up with is
C = 2 * Application.WorksheetFunction.Pi() * R
That works, but it's a litte messy.
|