VBA Question / Clearing out All Data

[Guest]

I would like to clear all my data that is in cell C4:J30000.

Is there a way to do this with a vba macro ?

Thank you in advance.

 

[Guest]

Sub test()
Range("C4:J30000").Clear
End Sub


HTH,
Gary Brown

 

[Guest]

thank you. that worked great for me.

is there a way to have only the data cleared out yet leave the formating
unchanged ?

regards.

 

[Guest]

Change to...

Range("A1:A10").ClearContents

HTH,
Gary Brown