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.