hi, at the minute I have been using the clear function to clear cells before my new info is entered automatically by a macro.

I want to delete all the text but leave the colouring and other formatting alone, so that they stay there.

Is there another command i can use instead of "clear" so that i can just delete the text.