Copying Formula When Adding Rows With Macro

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?

Please Login or Register  to view this content.

Originally Posted by angusfire

... Range("Date_List").Cells(0, 1).Row - 1 ...

What if cell "Cells(0, 1)" of the "Date_List" range is in row #1 ? Then 'Row - 1' = 0, but there is no row #0.
Give us an example of the data layout.

Attached is an example from my question. The table has a default number of rows (18) that will be the minimum. Additional rows will be added when the user entered date exceeds the last date in the table. The new rows would be added above the last row so that the previous formulas are copied down. The last row of the table has a different formula than do the rows above it. The way I currently have the code it copies the formulas correctly for each column of the table except for the first column. Once the code works correctly, I will be tying it to a worksheet change each time a new date is entered.

Look Here its working