VBA drag down formula : Hi friend i have apply formula in S column (=concatenate(p1,q2,r3) this formula has to copy down till A column end



 ` ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-3],RC[-2],RC[-1])"`

`Range("S1").Select`

`Selection.copy`

`Range("S:S").Select`

`ActiveSheet.Paste`

`Application.CutCopyMode = False`
