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.

Private Sub CheckBox1_Click()
Application.ScreenUpdating = False
    If CheckBox1 = True Then
    [16:18].EntireRow.Hidden = False
    Range("C17").Copy Range("C31")
    Else: [16:18].EntireRow.Hidden = True
    End If
Application.ScreenUpdating = True
End Sub