Clear range, exclude headers

[David2]

I'm trying to clear contents of a range of cells, A2-C100 but excluding headers (so technically A2-A100, B2-B100 and C2-C100).


How can I do this without specifying range for every column?

So far I had this:

Range("A2:A100").ClearContents
Range("B2:B100").ClearContents
Range("C2:C100").ClearContents

 

[Eric W]

Are the headers in row 2?

Range("A3:C100").ClearContents

 

[David2]

Doh Thanks.