I am trying to add a row on a bottom of my table depending on what checkboxes are checked. COLUMN B successfully pastes the checkbox.caption that has value = true but I want to add text on a specific cell adjacent with the same corresponding row of the checkbox that is checked.
I have this loop to check the true checkboxes:
and this code for the checkboxes:
The problem is that the result ends up like this: the first text with "aaaaaaaaa" gets replaced with "12121212121" of the second checkbox. Basically, the last checked checkbox's text overwrites all text in the column. I have 64 checkboxes.