Clear Content/data input from different Cells with a macro

[eChef]

Hi,

I like to place a macro into my worksheet which when clicked will clear my data input in different cells. I don't know if that is possible, but if it is then please can someone help.

example, I want to clear Cells A2 - A10, and B5 - B10, and D4 - D10, but with a macro, so that I do not have to go every time and manually delete the content.

hope it makes sense,
kind regards,
Matt

 

[sulakvea]

hi, just to clear the contents, you can do this:

sub ClearCont()
 range("A1:A10").clearcontents
 range("B1:B10").clearcontents
 range("C1:C10").clearcontents
etc.. 
etc..
etc..
end sub()

remove the ect etc etc piece, or add more ranges if you like - the logic is pretty straightforward

 

[eChef]

Hi,
thank you so very much, works fantastic.

 

[Peter_SSs]

You can clear lots at once if you like. Here's one way:

Sub Clear_Ranges()
    Const RangesToClear As String = _
        "A2:A10, B5:B10, D4:D10" '<- Add more if you want
    Range(RangesToClear).ClearContents
End Sub

 

[eChef]

Peter,
that looks very clean and compact, thank you.
great code....

Matt