As Mike says in post #5 you can use .ClearContents rather than .Clear. This will only clear the values and leave the formatting etc.

BSB