lundi 11 juillet 2022

Copying a row with ActiveX checkboxes and pasting onto row above

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