Range("K2").Copy _
Destination:=Range("K2:K3269")

To make it variable use another column to determine your last row like this

LastRow = Range("A" & Rows.Count).end(xlup).Row
Range("K2").Copy _
Destination:=Range("K2:K" & LastRow)


"Darius" wrote:

I have a formula in cell K2. How to copy this formula in every 72 cell
further in same column (K) up to cell rwo number 3269?