I have a table filled with activeX checkboxes that are each linked to their respective cells.
After clicking on a certain button, a new empty row is added above the last row (using: Range("xxx").EntireRow.Insert) .
What I want to achieve is copying and pasting the last filled row into the above 'new' row and then clearing the final row so it is the new 'entry row' with empty checkboxes.
I have tried copying and pasting with formatting etc but just cant seem to copy over the checkboxes.enter image description here
Any ideas?
Aucun commentaire:
Enregistrer un commentaire