VBA COS function

[Atholl]

I'm puzzled about the COS function in VBA. I know in excel you have to convert from radians to degrees by the command, for instance:
=COS(90 *pi()/180) which will return
6.12574E-17 (essentially zero)
If I use this in VBA, I get a #VALUE! reply in excel!
Does anyone know why this is happening?

Atholl

 

[ThePencilQueen]

Is the pi() function the same in VBA?

 

[Atholl]

Just tried it, and pi is being reported as equal to 0!!

This could be my answer!

Cheers,

Atholl