I'm trying to create a macro that will add columns with a header, and add a formula to each column.
This is the code I have so far.
Sub addcolumn()
Dim Formulas(1 To 5) As Variant
Dim LastRow As Long
Worksheets("Combined Pivot").Range("R:V").EntireColumn.Insert
Worksheets("Combined...