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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculations
electricpete, Your solution worked for me, I had my I=I+1 switched! Frustrating! Thanks for your help! Thank you everybody for all your help, I appreciate it. I learned a lot from the discussions! I hope to return the favor someday.- GoodB
- Post #14
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Calculations
Here is what I have so far... Sub Calc() Dim RowVar, ColVar, Sum, Integration As Double Dim I As Integer RowVar = 3 ColVar = 12 I = 0 Sum = 0 Range("L3").Select Do I = I + 1 Sum = Sum + Integration Integration = (1 / 2) * (Cells(RowVar + I, ColVar + 1) -...- GoodB
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Calculations
That's the thing, I'm not really sure how to start the code. I have done code like this in the past but I can't remember how to do it, it's been a few years... Here is what I recorded with the macro recorder. Sub Calc() Range("J24").Select ActiveCell.FormulaR1C1 = _...- GoodB
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Calculations
Good Mornin' Macropod, I'm using MS Visual Basic.- GoodB
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Calculations
I have an equation with 4 variables. I would like to be able to input any amount of rows of data into the spreadsheet. There will be 4 columns and multiple rows. Each is calculated separatly and then the sum will be calculated at the end. This is integration... Example: Row1: a, b, c, d...- GoodB
- Thread
- Replies: 14
- Forum: VBA Visual Basic for Applications (Microsoft)
