Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Acos Function
It is my understanding that Visual Basic does not have
the acos (inverse cos) built into it. I want to then have visual basic place a formula in a cell rather than a value. How do I do that. Here is what I have. Thank you. Klarge and PFlarge are defined integers wks_W.Range("AH" & i).Value = Klarge * Tan(Acos(PFlarge)) * wks_W.Range("S" & i).Value Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Acos Function
Acos is a worksheet functions available in VBA. Highlight
Acos and press F1.. Don't forget the Trig functions work with Radians - is that what your defined integers refer to (rather than degrees). Sub test() Dim fn As WorksheetFunction Set fn = Application.WorksheetFunction x = 30 * fn.Pi / 180 cs = Cos(x) ac = fn.Acos(cs) x2 = ac * 180 / fn.Pi MsgBox x2 End Sub Regards, Peter -----Original Message----- It is my understanding that Visual Basic does not have the acos (inverse cos) built into it. I want to then have visual basic place a formula in a cell rather than a value. How do I do that. Here is what I have. Thank you. Klarge and PFlarge are defined integers wks_W.Range("AH" & i).Value = Klarge * Tan(Acos(PFlarge)) * wks_W.Range("S" & i).Value Thank you . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modified ACOS function | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |