how to clear my content in cells but keep the conditional formatti
 

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??

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??