Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Storing formula's in an array, calculating SUM in the array then
returning result into a cell without formula. this basically does the calculation however the formula is in the cell so far i have ....... Sub FormulaTest() Dim myFormula(0 To 5) As String Dim myresult(0 To 5) As String Dim myFlag As Boolean Dim x As Integer Dim i As Integer Dim Result As String Dim qwerty As Variant 'Select cells A10 to A15 Range("A10:A15") = "" 'Fill the array with formulas myFormula(0) = "=SUM(10+12)" myFormula(1) = "=SUM(20+12)" myFormula(2) = "=SUM(30+12)" myFormula(3) = "=SUM(40+12)" myFormula(4) = "=SUM(50+12)" myFormula(5) = "=SUM(60+12)" Do Until myFlag = True For i = 0 To 5 'NEED SOME CODE IN HERE } need to keep the result of the formula and put it in the next cell ' ActiveCell = myFormula(i) } this will enter the formula along with the result in the cell ActiveCell.Offset(1, 0).Select } moves to the next cell down If i = 5 Then myFlag = True: Exit For End If Next i Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Calculations with Calculated Results | Excel Worksheet Functions | |||
N/A results on vlookup with time calculations | Excel Worksheet Functions | |||
How can I output VBA function results (array's for example) to spreadsheet | Excel Worksheet Functions | |||
Help on performing calculations on formula results | Excel Worksheet Functions | |||
Getting results from VBA calculations into cells | Excel Programming |