If you're wanting to know what's wrong so you can fix it, this should be of some assistance.

The While loop is looking for the length of values in the cells of column A and there are no values in column A. Even the check boxes aren't actually in the cells, they are on the cells.

The "TRUE" being looked for in column K doesn't exist. While this isn't an error for Excel, it is for the way you're wanting to use it. The use of the quote marks around true makes it a string and what the check boxes are putting into the cells is Boolean in the form of true and false so the quotes need removed.

The select row to copy... Rows( a number here ) is an entire row, nothing additional needed.

The entire row would be 16,384 cells, and you're wanting to copy 8, so the entire row is a little excessive.
You can specify the range to copy ie: range("B" & the row & ":I" & the row).Copy
and where to paste it, which need only be one cell ie: range("A" & the row) all on one line with no selects or pastes.


If you're looking for someone to fix this for you or suggest some other way, then that's what you need to ask.