PC Review


Reply
Thread Tools Rate Thread

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

 
 
Oligo
Guest
Posts: n/a
 
      18th Mar 2009
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 Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      18th Mar 2009
Try

Range("A11").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 Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear Cells Content No_Spam Microsoft Excel Misc 2 20th Aug 2006 04:01 PM
How do I or can I put a vlookup or hlookup in conditional formatti =?Utf-8?B?Q2hyaXN0aW5hQw==?= Microsoft Excel Worksheet Functions 0 12th Apr 2005 03:52 PM
should be possible to add more conditions to conditional formatti. =?Utf-8?B?ZXhjZWxfamFu?= Microsoft Excel Misc 3 9th Feb 2005 06:41 PM
Clear the content of cells Yee Microsoft Excel Misc 1 11th Mar 2004 06:47 AM
Clear the content of cells Yee Microsoft Excel Misc 0 11th Mar 2004 03:54 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:35 PM.