I need to figure out how to modify the VBA below to have my variable populate in the formula that is being written into the cell.
Thank you for your help
VBA Code:
Sub Test()
Dim mth As Variant
mth = Range("NSDateMonths").Value
With Range("U18")
.FormulaR1C1 = _
"=DATE(YEAR(Origination_Date),MONTH(Origination_Date)+mth,DAY(Origination_Date))"
Range("U19").Select
Range("U19").Value = mth
End Sub
Thank you for your help