Thread: clear the values, but not the formulas in a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aidy aidy is offline
external usenet poster
  
Posts: 1
Default clear the values, but not the formulas in a range
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