Range("f65536").end(xlup).offset(1,0).formula = "=F9*-1"
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.
ActiveCell.FormulaR1C1 = "=R[-10]C*-1"
I know this is probably simple. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)