Pi not defined?

XL2007, sp1:

In a VBA module doing some trigonometry, I want to use the value of pi. Yet when I compile, Pi is highlighted as "variable not defined", although it is listed as an available worksheet function. Pi(), when compiled, returns sub or function not defined.

And the workaround is...?

[and searching on pi doesn't help. sorry.]

TIA.

George

Perhaps you mean

Dim dblPi As Double: dblPi = Application.Pi

That makes sense but to reiterate you can just use Application.Pi, the below

Dim Pi As Double: Pi = PI()

is not a valid VBA expression... ie you were trying to use Native XL syntax in VBA which isn't going to work I'm afraid unless encased within an Evaluate call, eg:

Dim Pi As Double: Pi = Evaluate("PI()")

Or as outlined using VBA syntax, either of:

Dim Pi As Double: Pi = Application.Pi

Dim Pi As Double: Pi = WorksheetFunction.Pi

Hopefully this will help you as you move forward and use other Native Functions directly from VBE.

If you read my post you'll note I first said:

"That makes sense"

I should perhaps have clarified that this related to using a Public Constant....

I was merely trying to make a point re: your initial post / question and how you can / should handle XL's native worksheet functions when calling from VBA ... plainly I'm failing in my objective so I shall not muddy the waters further
(confirmed by the example you used in your last post... ie the only one I posted that I said wouldn't work!)