Checkbox to unhide rows then copy and paste

Hello,

I am pretty new to VBA and I have created a Checkbox and I am looking for when the Checkbox is checked it unhides rows 16:18 AND copies information from cell C17 (Merged cell) and pastes to cell C31 (also a merged cell). If the CheckBox is not checked then rows 16:18 stays hidden and the copy and paste function does not happen. The code I have below does not work as I get the error 'Run Time Error '1004' We cant do that to a merged cell.'

If anyone can provide some assistance it would be greatly appreciated.

Please Login or Register  to view this content.

Perhab like this

Please Login or Register  to view this content.