Thread: how to clear my content in cells but keep the conditional formatti
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how to clear my content in cells but keep the conditional formatti
Try

Range("A1:D1").ClearContents

Mike

"Oligo" wrote:

currently i have a 2 macro one that tabulate my output data another that
clear the data table for next tabulation.

how do i write the code for clear contents such that the conditional
formatting of my table remain and the no. of decimal places also remain??
Reply With QuoteReply With Quote