Thread: Pi in VBA?
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Pi in VBA?

You didn't like this one?

PI = 4 * ATN(1)

--
Rick (MVP - Excel)


"Prof Wonmug" wrote in message
...
On Tue, 28 Apr 2009 15:56:17 +1000, "AltaEgo" <Somewhere@NotHere
wrote:

Set a variable and use the variable

PI = Application.WorksheetFunction.Pi()

C = 2*PI*R


Yep, that's probably the best I can do. Thanks.