It doesn't matter weather they are or not, as long as when I go to print the table the added rows an columns look like they are part of the table its fine. I cant use a macro because the table is dynamic here is what I mean.

Ok so I have a assignment from work where I gotta make a dynamic table because the table will be used by all kinds of people for the next few years. It will expand in size and to make it easier, I decided to use a button to add rows and columns. So whatever is the last row/column the button will continue from that and add more columns an rows 1 at a time. Now ive done this both with your code an my OP, but since the table has rows with alternating colors in a pattern, it doesn't fully copy the colors. In my OP the code generates the row, but only fills them with color once you input text in the cell.

This can be misleading to other people who might think the button is not working when in fact it is, because the cells get generated but there are no cell colors UNLESS they type text. Your code does this but not really getting the proper colors for the ROWS.