Clearing out cells in a column before writing to them

[Turtleman10]

I am attempting to clear out a range before I write to it. I tried this code but unfortunately it also clears out all the formating. any suggestions?

 Range("SQLMatl").Clear
     Range("IQty").Clear
     Range("Comments").Clear
     Range("MatlQ").Clear

[oeldere]

Probably with clear.content

[AB33]

As per Oeldere suggestion

Range("SQLMatl").ClearContents
     Range("IQty").ClearContents
     Range("Comments").ClearContents
     Range("MatlQ").ClearContents