The Macro Affect some cells font formatting

[Ramadan]

I have a worksheet with a table and a macro to insert new row to the table. under the table there is a total row doesn't included in the table range

the problem is every time when I click the macro button to add new row the font format of the total row below the table changes from bold to regular only in 2 cells as you can see in the screenshot "F179" & "L179" and I don't know what's the wrong in the code to do that..

[Sub Addnewrow()

Dim ws As Worksheet
Dim newrow As ListRow

Set ws = ActiveSheet

Set newrow = ws.ListObjects("Data").ListRows.Add

With newrow
.Range(12).FillDown

End With

End Sub]

 

[MikeVol]

under the table there is a total row doesn't included in the table range

Why do you need this additional row under the table? In it, you can show the Total row. Read next:
The VBA Guide To ListObject Excel Tables
Good luck.

 

[Ramadan]

Actually, I tried to incerease the space between the table and the total row and it worked now it's ok