I've looked around quite a bit but haven't found a solution yet. I'm looking for VBA to copy a Range of Cells with Conditional Formatting (in Excel 2010) to another sheet and paste the contents including the Conditional Formatting Formats (but without the Rules). Restated, I want the copied range to look just like it does on the source sheet but since the Conditions don't exist on the destination sheet, I need a way to Paste the fully formatted contents).
I've seen suggestions elsewhere about Pasting to Word and then copying back to Excel but I'm hoping there's a fully automated solution here.
Thanks for anyone's insights.