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.

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


HTH,
Gary Brown

"carl" wrote:

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.

thank you. that worked great for me.

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

regards.

"carl" wrote:

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.

Change to...

Range("A1:A10").ClearContents

HTH,
Gary Brown


"carl" wrote:

thank you. that worked great for me.

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

regards.

"carl" wrote:

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.