Copy/Paste with cell comments and check boxes

[ExcelBruh]

Having some issues with copy/pasting. I attached a very simplified work book to kind of show what I'm doing. it's grabbing everything and formatting it correctly except the cell comments and check boxes. See notes in the workbook.

[Greg M]

Hi there,

See if the attached code does what you need - it creates a temporary copy of the active worksheet, moves the required range (complete with CheckBoxes, Comments etc.) from the temporary worksheet to Cell A1 on the original worksheet, and then deletes the temporary worksheet:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[ExcelBruh]

Works great. Thank you, Greg.

[Greg M]

Hi again,

Sorry about the delay in replying - I was away for a while.

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're very welcome - glad I was able to help.

Best regards,

Greg M