Copy Conditional Formatting w/out the CF Coding

[Rob]

I searched all over the community to see if I can find what I am looking for
but I either missed it or it isn't available. What I am trying to do is,
with VB, copy an entire worksheet and then paste it back into the same
worksheet BUT only the values and all formattings... except I want the
conditional formats to actually be converted from conditional formatting to
actual formatting.

In other words, with the original uncopied data the conditional formats have
formulae in it to do the coloring. When it is copied I want it to still have
the coloring applied as it was/is but not actually have conditional
formatting to color it.

I've tried all sorts of ways with the pastespecial xlvalues/xlformats/etc.
but nothing gets rid of the conditional formats and yet still keep the
coloring.

Is this possible?


Thanks In Advance!
Rob