Forum Discussion
Solved
macro in excel
When writing a macro in Excel, the following command calculates the contents of the cells relative to the current cell.
ActiveCell.FormulaR1C1 = "=R[-11]C[1]-R[0]C[3] "
How do I define the cells absolutely, so that the definition does not depend on the current cell position?
- Thank you. You helped me a lot!
