.Clear alternative

[dave3009]

Hi Folks

I have a reset values button on a sheet

I use .Range("Range").Value = "" in my code to clear it. Is there a better option.

I used .Clear but it also cleared formatting

Thanks



Dave

 

[thenextguy]

.clearcontents will leave the formatting.

 

[dave3009]

I'll use that. Thank You very much