Atholl
Active Member
- Joined
- May 19, 2002
- Messages
- 436
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
=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