I have a spreadsheet that contains about 300 rows and in each row there is a checkbox that is linked to a cell in that row. If the checkbox is "checked", the macro I have developed copies the data in the row, moves it to another worksheet, pastes it, and then returns and deletes the row. What I have found however is that the checkbox remains after the row has been deleted.
So I need a macro that will delete a checkbox in a row that is also being deleted. The rows can be deleted as individual rows or multiple groups of rows, not necessarily adjacent to each other. In other words, the rows to be deleted can be any one of the 300+ rows.
The checkboxes are located in column B. The data to be removed is in columns C through M.
Can anyone help?
Bookmarks