clear the values, but not the formulas in a range
If a formula evaluates to a value, you can't clear the value without
eliminating the formula. You can hide the value by making the font color
match the background, if that is what you want to do. Or just hide the cells.
--
- K Dales
"aidy" wrote:
I'm trying to clear the values, but not the formulas in this range?
Range("E3:F3, E5:F5").ClearContents
Is it possible?
Cheers
Aidy
|