Hi Team,
Need help in passing variable in below Recorded Code.
Recorded code :=> ActiveCell.FormulaR1C1 = "=SUM(R[-38]C+R[-36]C+R[-34]C)"
My Variable Range as follows. I have found Range via find method. need to pass these variable in above recorded formula.
rng_TelReimbursement
rng_DvrSalary
Rng_Fuel
Attempted Code
Thanks
mg
Need help in passing variable in below Recorded Code.
Recorded code :=> ActiveCell.FormulaR1C1 = "=SUM(R[-38]C+R[-36]C+R[-34]C)"
My Variable Range as follows. I have found Range via find method. need to pass these variable in above recorded formula.
rng_TelReimbursement
rng_DvrSalary
Rng_Fuel
Attempted Code
VBA Code:
With Sheet1
With .Range(.Cells(50, 4), .Cells(50, lc + 1))
.FormulaR1C1 = "=SUM(R[" & rng_TelReimbursement.row & " ]C+R[" & rng_DvrSalary.row & "]C+R[" & Rng_Fuel.row & "]C)"
End With
End With
Thanks
mg