Copy/Paste sheet without all the conditional formatting 
Author Message
 Copy/Paste sheet without all the conditional formatting

Hello All
I have code copying a sheet, pasting it into another workbook and saving the
workbook. All works well but I would just like to be able to paste the sheet
without all my conditional formatting going with it. I need to keep the
colors but not the conditional format that put them there. Many thanks for
your time.
Paul


Thu, 27 Jan 2005 10:35:20 GMT  
 Copy/Paste sheet without all the conditional formatting
Hi Paul:

It would be quite complicated and would have to be done on a
cell-by-cell basis. See Chip Pearson's explanation and code at:

http://www.cpearson.com/excel/CFColors.htm
--
Regards,

Vasant.

**No direct emails please--keep discussion in newsgroup.**


Quote:
> Hello All
> I have code copying a sheet, pasting it into another workbook and
saving the
> workbook. All works well but I would just like to be able to paste the
sheet
> without all my conditional formatting going with it. I need to keep
the
> colors but not the conditional format that put them there. Many thanks
for
> your time.
> Paul



Thu, 27 Jan 2005 11:04:29 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. !! copying and pasting without activating the destination sheet !!

2. Copy and paste special values without switching sheets

3. Copy/Paste Special without making sheet visible...

4. Copy/Paste conditional format

5. Copy Sheet to Word without table format

6. How to copy cells to another file without copying and pasting

7. Copy/paste sheet to sheet

8. copy/paste from sheet to sheet

9. Paste format - all but the conditional formatting ??

10. Want to copy a Web Page and paste to Word without copying hyperlinks


 
Powered by phpBB® Forum Software © phpBB Group