VBA to Insert 21 Table Rows; Format as Below

Hello all,

I've been doing a lot of searching on this topic, as not to bog down the forum, but I just can't find the right code. I'm very new to VBA.

I have simple table that I would like to insert 21 rows to it when the user clicks a command button (I know how to assign code to a button).

The number of rows will always be 21, and, will always be inserted at the first row of the table (ie, Table Rows Above) . When the 21 rows have been inserted, the formulas in the previous 1-21 rows should auto fill into the new set of 21 rows.

I tried using the macro recorder to do this, but it doesn't seem to work. When searching for VBA code, it seams most of the answers only insert 1 row at a time. Some of the answers refer to looping in order to get to 'n' rows.

Can multiple rows be added to a table object at once with VBA, or does it require a loop? Is there a link to this code?

Thank you!
-Rich

My apologies. A created/inserted table, as described in your link, and named "AFG".

Solved. Thank you kindly!