CODEWITHSUNDEEP
excelvba
inun
inun

Reputation: 9

VBA code copying forrmula pattern down a column

Please help with VBA code .I have formula in excel sheet in cell F6 want to copy same formula down that same F column after every 14th row the last formula will be inserted in in cell F2533 .Thanks for your help in advance

Upvotes: 0

Views: 55

Answers (1)

JNevill
JNevill

Reputation: 50034

Something like the following should get you close:

Sub copyformuladown14()
    copyRange As Range

    'Set range variable to F6 on sheet1
    Set copyRange = Sheet1.Range("F6")


    'Starting at row 20, loop every 14 rows and paste
    'you have to monkey with number "20"
    For i = 20 To 2533 Step 14
        copyRange.Copy Destination:=Sheet1.Range("F6").Offset(i)
    Next i
End Sub

Upvotes: 1

Related Questions