T
Tami
i'm trying to writ a macro that enters in a formula in a cell.
Scenario:
Assume my cursor is in row 8
I want to put a formula of "=O$9" in cell M9
Here's what i've got so far (but its not working)
dim x as integer
lr=activecell.row 'tells me what row i'm on
x=lr+1 'adds 1 to row number
cells(x,13).select 'move my cursor to column M of row x
ActiveCell.FormulaR1C1 = "=+RxC[2]" 'put the O$x formula in
thanks in advance for any assistance.
tami
Scenario:
Assume my cursor is in row 8
I want to put a formula of "=O$9" in cell M9
Here's what i've got so far (but its not working)
dim x as integer
lr=activecell.row 'tells me what row i'm on
x=lr+1 'adds 1 to row number
cells(x,13).select 'move my cursor to column M of row x
ActiveCell.FormulaR1C1 = "=+RxC[2]" 'put the O$x formula in
thanks in advance for any assistance.
tami