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
Bookmarks