Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |