Hi,
Use:
SIN(angle)
COS(angle)
TAN(angle)
All of these work in VBA as written above, however, they will fail if
written as
WorksheetFunction.Sin(angle)
or if the angle is in degrees not radians then convert to radians using
WorksheetFunction.Radians (22.5)
So your formulas might look like this
SIN(WorksheetFunction.Radians (22.5))
If this helps, please click the Yes button
Cheers,
Shane Devenshire