Copy/Dragging Formulas in VBA

[GeneralShamu]

I have a formula in cell N2, O2, P2.

I want to copy that formula into every row down to row n. Where n is a variable defined earlier in the code.

Does anyone know an easy way of doing this, either with Cells or Range?

 

[njimack]

Range(Cells(2, 14), Cells(2, 16)).Copy Range(Cells(3, 14), Cells(n, 16))

 

[cb12]

Try:

Range("N2:P2").Copy Destination:=Range("N2:P2").Resize(n, 3)

 

[GeneralShamu]

Try:

Range("N2:P2").Copy Destination:=Range("N2:P2").Resize(n, 3)

Thank you; this worked beautifully!