Thread: Pi in VBA?
View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pjbhaumik@gmail.com is offline
external usenet poster
 
Posts: 1
Default Pi in VBA?

On Tuesday, April 28, 2009 1:00:22 AM UTC-4, Prof Wonmug wrote:
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.


This helped. Thank you.