Thread: clear the values, but not the formulas in a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default clear the values, but not the formulas in a range
Hi

You can use

On Error Resume Next
Range("E3:F3, E5:F5").SpecialCells(xlCellTypeConstants).ClearCon tents
On Error GoTo 0


--
Regards Ron de Bruin
http://www.rondebruin.nl


"aidy" wrote in message ups.com...
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