Jun 27, 2014
My goal is to write an equation that allows me to total all of the numbers in a column until the value = 0.
View 1 Replies
When I write the following equation using actual cell references, I am able to get the results I am looking for:
When I try to write it in a macro using variables, I get all messed up:
Selection.Font.Italic = True
ActiveCell.FormulaR1C1 = " Expense"
(Possibly unnecessary information: This is for a budget spreadsheet I am creating. Ideally when I am finished with the macro it will allow me to add a line item under a specific program and update the total amount spent. The budget is broken out by month, rather than program. When a new program begins the amount in column J will always be zero, hence the Sum until 0 is reached.)