Thread: clear the values, but not the formulas in a range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
  
Posts: 1,163
Default clear the values, but not the formulas in a range
Just realized you probably have a mix (unknown to you) of cells with formulas
and values. Try Range("E3:F3,
E5:F5").SpecialCells(xlCellTypeConstants).ClearCon tents.
--
- 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


Reply With QuoteReply With Quote