VBA Question / Clearing out All Data

[carl]

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.

 

[Gary Brown]

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


HTH,
Gary Brown

 

[carl]

thank you. that worked great for me.

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

regards.

 

[Gary Brown]

Change to...

Range("A1:A10").ClearContents

HTH,
Gary Brown