I have a macro that add rows to a range. The new rows copy the formula from the row above correctly except for the first column. Any suggestions?
VBA Code:
m = Range("Add_Months").Value
Application.CutCopyMode = False
Rows(Range("Date_List").Rows.Count + Range("Date_List").Cells(0, 1).Row - 1).EntireRow.Select
Rows(Selection.Row).Copy
Rows(Selection.Row).Resize(m).EntireRow.Insert Shift:=xlDown
Application.CutCopyMode = True