VBA looping through specific columns

[pvman]

Hello All
I am looking for a way to loop through specific columns
i.e. columns # 27,30,38,39,47,48,50,52,53,54,61,72,74,75,76,77,78,79
and in each of those columns, copy a formula from the first cell at the top of that specific column, down to all the rows in that column (lets say from line 3 to line 1000).
Each column have a different formula at the first upper cell.
Any thoughts how to go about it?
TIA

 

[Fluff]

How about

Sub pvman()
    Dim Txt As String
    Dim UsdRws As Long
    Dim Rng As Range
    
    Txt = "AA:AA,AD:AD,AL:AM,AU:AV,AZ:BA,BB:BB,BI:BI,BT:BT,BV:CB,CD:DA"
    UsdRws = Range("A" & Rows.Count).End(xlUp).Row
    For Each Rng In Range(Txt).Areas
        With Rng.Resize(1).Offset(2)
            .FormulaR1C1 = Rng.Resize(1).FormulaR1C1
            .Resize(UsdRws - 2).FillDown
        End With
    Next Rng
End Sub

 

[pvman]

How about

I must admit that I don't fully understand the code, but is looks like it does exactly what I need, so THANK YOU VERY MUCH

 

[Fluff]

Glad to help & thanks for the feedback