Whenever I use the following VBA Code to add a row to my table it does not carry with the row widths of the spreadsheet. It use to but no longer does not sure I changes a setting or??
Before I add the row to the bottom of table C-Subcontractors Row 422.
After I add a row to the bottom of table C-Subcontractors Row 422.
As you can see row widths for row 426 and 427 stayed the same and squished my header row instead of moving down like it use to.
Any Ideas?
VBA Code:
sTableName = ActiveCell.ListObject.Name
Set oSheetName = Sheets("Construction Budget")
Set loTable = oSheetName.ListObjects(sTableName)
'Add New row to the table
loTable.ListRows.AddBefore I add the row to the bottom of table C-Subcontractors Row 422.
After I add a row to the bottom of table C-Subcontractors Row 422.
As you can see row widths for row 426 and 427 stayed the same and squished my header row instead of moving down like it use to.
Any Ideas?
