Add Row not copying formula from cell above

[WxShady13]

I have a macro that adds a new row to a table. It will copy the formula correctly in column A but it doesnt in column B. I dont know why it is doing this.

Sub AddRow()
Dim ws As Worksheet
Set ws = ActiveSheet
Dim tbl As ListObject
Set tbl = ws.ListObjects("PayData")
'add a row at the end of the table
tbl.ListRows.Add
'add a row as the fifth row of the table (counts the headers as a row)
'tbl.ListRows.Add 5
End Sub

 

[Joe4]

Is column B really in your table?
Or perhaps was it added after the fact and actually resides outside of your table?
What are the formulas in columns A and B?

 

[WxShady13]

The table was built and then the code added. Column B was included from the beginning.

Column A= Just adds 7 days to the date in the cell above
Column B= =SUM(E6+$L$2) this totals the Outstanding Balance from the week before and the Weekly Premium in the Employee Info table

 

[Joe4]

Can you give us the actual formula that resides in column A too?
And then post a small sample of your data?

I would like to try to recreate this on my side to see if I can reproduce the behavior you are describing.

By the way, you do NOT to use SUM in your formula. Using SUM and + is redundant. You only need one or the other.
So change that formula to:

=E6+$L$2

By the way, is your table TRULY a data table in Excel?
I ask because typically your formula would not look like this:

=SUM(E6+$L$2)

Table formulas typically use heading/field names instead of range references.

 

[WxShady13]

=A8+7

 

[WxShady13]

 

[WxShady13]

Hey I actually fixed it. So apparently when the table was created Column B had a formula. When I created a new formula it was not picking up the changes for the new rows. I changed the table to a range and then back to a table and boom it works! Thank you for the help

 

[Joe4]

Hey I actually fixed it. So apparently when the table was created Column B had a formula. When I created a new formula it was not picking up the changes for the new rows. I changed the table to a range and then back to a table and boom it works! Thank you for the help

That is kind of what I suspected.
Glad you got it figured out and working!