I am trying to just generate 1 column and 1 row at the end of a table at the click of a button(since the people using the spreadsheet are computer illiterate). your code does this meaning I can implement it into one button however, for some reason since the table alternates colors meaning one row gray, the other light gray, the code adds the correct column with the correct color, but the row it generates always has the same color
FYI the text is just there for testing.
Notice only column A is the only column that alternates while B21-B26, all the way to the rows L21-L26 and so on and so forth do not?


I need the Generated rows color to alternate just like the previous rows. Dont worry about the columns because those work its just the rows.

And thank you for helping me this far because you eliminated the need for having 2 buttons and even a user input.

Looks to me like you may have missed the red part of this line
The right color is being applied but only to the starting cell of the range.

It would be far easier to be sure if you would post the sheet with the code rather than a picture of the sheet and no code. (This isn't MrE. Excel files can be posted here.)

On second thought that's not right. The new row being added is not always immediately below "the table".
I'll have to adjust for that.... I'll be back shortly.

ok and thank you for helping me this far. here is file