formuls
Hi
est0 set to column B because I don't know how you set that
Private Sub FindMemoRow()
est0 = "B"
For i = 1 To 10
Range(est0 & i).FormulaR1C1 = _
"='Estimate Costs'!R[" & i & "]C[7]&"" ""&'Estimate Costs'!R[" & i & "]C[8]"
Next
End Sub
Mike
"ranswert" wrote:
[i]
I need to write a code that inserts a formula into a cell.
The code is:
Range("est0" & i).FormulaR1C1 = _
"=('Estimate Costs'!R[i]C[7]&"" ""&'Estimate Costs'!RC[8])"
The row needs to increment 'i' down each time I insert the formula.
I get an error when it is run. I have i as an integer.
What am I doing wrong?
Thanks
|