Hi,
I am trying to create a macro to (when run) go through all the values starting in Column c in rows 3 & 4 (spreadsheet outline below) and subtract them from each other and populate row 5, then moving onto column C and do the same and untill it reaches a column that only has data in row 3 or 4 but not both and wont proceed in the calculations until both the cells are populated.
Range("C5").Select
Range(Selection, Selection.End(xlToRight)).Select
Offset(1).FormulaR1C1 = "=R[-2]C-R[-1]C"
I have a spreadsheet as below:
<colgroup><col style="width: 48pt;" span="7" width="64">
<tbody>
</tbody>
I am trying to create a macro to (when run) go through all the values starting in Column c in rows 3 & 4 (spreadsheet outline below) and subtract them from each other and populate row 5, then moving onto column C and do the same and untill it reaches a column that only has data in row 3 or 4 but not both and wont proceed in the calculations until both the cells are populated.
Range("C5").Select
Range(Selection, Selection.End(xlToRight)).Select
Offset(1).FormulaR1C1 = "=R[-2]C-R[-1]C"
I have a spreadsheet as below:
| 1 | A | B | C | D | E | F |
| 2 | ||||||
| 3 | 1 | 1 | 2 | |||
| 4 | 1 | 1 | ||||
| 5 | 2 | 2 | ||||
| 6 | ||||||
| 7 | ||||||
| 8 |
<colgroup><col style="width: 48pt;" span="7" width="64">
<tbody>
</tbody>
