Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Rounding off error
When I calculate in the VB editor I get round off errors. I have the following: Excel cells: E3 is =CalcResult(C3;F3;B3) (Sending the values to the VB editor) C3 is changeable, 1 to 6 CF is changeable, 1 to 6 B3 contains the value I want to calculate In VB Editor: Function CalcResult(Arg1 As...- Rixn
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How use cell value in a calculation?
Hi All! 1) In the Visual Basic Editor I want to know what is the correct way to refer to a cell so I can use its value in a calculation? Here's my code: Function CalcValue(Arg1 As String, Arg2 As String) As Long If Arg1 = "1" And Arg2 = "2" Then CalcValue =...- Rixn
- Thread
- Replies: 19
- Forum: VBA Visual Basic for Applications (Microsoft)
