Hi
I am looking for a macro that copies the formula in cell A1 and autofills row1 till the last filled column in row2.
Sub AutofillColumnsInRow1AccordingToLastFilledColumnInRow2()
Dim lastColumn As Long
lastColumn = Range(Columns.Count & 2).End(xlToLeft).Column
Range("A1").AutoFill...