Add multiple blank rows to the bottom of an Excel table

[Marro]

I've searched everywhere to an answer to my question but every answer has conditions, such as every other row, or when a condition exists or using a msgbox. I want to add 5 blank rows to the end of my Excel table with no other requirements. My table is named Backhaul_Table. That's it. I know how to just add 1 row but how can I modify it to add multiple?

I've read about loops but I'm not sure how to actually do it. Oh, did I mention I'm new?

This is what I'm doing to add one row

Dim ws as worksheet
set wb = thisworkbook
set ws = wb.sheets("Backhaul Tracking Sheet')

ws.ListObjects("Backhaul_Table").ListRows.add alwaysinsert:=True

 

[oldbrewer]

you can have a helper cell somewhere that tells you you have 20 rows in your table - but if that is the end of your table it already has blank rows beneath it - or maybe only 1 row spacing between it an a second table........

 

[Marro]

The table has formulas in several of the columns so I should have clarified that rows won't be entirely blank. I know by inserting the rows in the table it will bring the formulas along and the formats

 

[Marro]

What is a helper cell?

 

[oldbrewer]

a helper cell is just a cell usually out of sight that does an intermediate calculation to avoid you having to construct long and calculated formulas