[Solved] VBA: Absolute Cell reference in macro

  • Hello everyone, with the following lines of code I'm trying to get the value of cell F:9 multiplied by -1 and returned in the next empty cell. However, it wants to calculate the number of rows up (i.e. "=R[-10]C*-1") rather than using the cell reference F:9. I've tried a couple of things but haven't gotten it yet.

    Range("f65536").End(xlUp).Offset(1, 0).Select
    ActiveWindow.SmallScroll Down:=-1
    ActiveCell.FormulaR1C1 = "=R[-10]C*-1"

    I know this is probably simple. Thanks for the help.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!