vba help - R1C1 formula not working

[Mallesh23]

Hi Team,

Need help in below Formual , I am unable to add 15 days to existing date Column.
getting errror.

Delivery_Date  = 5
DateAdd = 15

'Attempted code
With wsMaster
         With .Range(.Cells(3, 6), .Cells(lr_master, 6))
            .FormulaR1C1 = "=RC " & Delivery_Date & "" + DateAdd
         End With
End With

Recorded
Range("F3").Select
ActiveCell.FormulaR1C1 = "=RC[-1]+15"


Thanks
mg

 

[RoryA]

It should be:

.FormulaR1C1 = "=RC" & Delivery_Date & "+" & DateAdd

 

[Fluff]

How about

.FormulaR1C1 = "=RC" & Delivery_Date & "+" & DateAdd

I would advise against using DateAdd as a variable name as it's a VBA keyword.

 

[Mallesh23]

Hi Rory and Fluff,

Thanks for your help it worked. I will change dateAdd variable.
thanks for highlighting it. ?



Thanks
mg

 

[Fluff]

Glad we could help & thanks for the feedback.