MiguelCSUN
04-19-2010, 01:50 PM
I am trying to update a set of equations based on a new data points.
ActiveCell.FormulaR1C1 = "=ROUND((R[5]C-R[1300]C)/60,1)"
Is there a way to use variables or a named cell to change the rows? What i would like to do is name a cell start and type 5 in it and name a cell finish and type 1300 and run the macro to update the equations as if the equations were written as:
ActiveCell.FormulaR1C1 = "=ROUND((R[start]C-R[finish]C)/60,1)"
ActiveCell.FormulaR1C1 = "=ROUND((R[5]C-R[1300]C)/60,1)"
Is there a way to use variables or a named cell to change the rows? What i would like to do is name a cell start and type 5 in it and name a cell finish and type 1300 and run the macro to update the equations as if the equations were written as:
ActiveCell.FormulaR1C1 = "=ROUND((R[start]C-R[finish]C)/60,1)"