Const in front of all my functions

[Philosophaie]

I want to have a value for PI for all my functions. I put this:

Const Pi = Application.WorksheetFunction.Pi

in front of all my functions. Where am I going wrong?

 

[xenou]

A constant must be a primitive value (string, number, date, True/False). I don't think it's possible in VBA to assign it a value that must be calculated. Too bad it's not a vba inbuilt constant (somewhat surprised at that in fact).

Personally I'd just go:
WorksheetFunction.Pi
when you want pi.

I suppose if you know what level of precision you need you could also define it yourself:
Const pi = 3.14159265