View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nils Titley Nils Titley is offline
external usenet poster
 
Posts: 84
Default Using PI in a macro

Thanks all for responding. I am using the Application.Pi(). It is working
but I will also try the others.



"Nils Titley" wrote:

I know PI can be used in a formula in for a cell. I am writing a macro to
provide the same formula while process other data.

When I try to use it, I get a compile error, sub or function not defined.

It is a complicated formula but (Cos(D1031 * Pi() / 180)......

Is there some thing I have to use PI?

Thanks