Clear Dynamic Range

[ionelz]

Hello,
I would like a simple code for Clear Content of Range
Dynamic Value is in cell C3
Dynamic Columns are F,G,H,I,J,K,L,M,N,O,P,Q so 12 Columns
If C3=3 then Clear Range I4:Q6
If C3=10 then Clear Range P4:Q6
If C3=6 then Clear Range L4:Q6
Basic, Clear Content of end range
Thank you

 

[maxpit]

Insert this Sub in the sheet where you are to make the deletions

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$C$3" Then
        Call Test1
    End If
End Sub

Now when you modify the contents of cell ‘C3’, the deletion of the contents will also be activated.