I created a macro that opens a workbook, copies information from that workbook, then pastes the information into a "destination" workbook. The problem is, conditional formatting exists in the workbook where the information is being copied, and when the information is pasted into the destination workbook, an external link is created.
Is there a way to paste values and formats without the conditional formatting also being pasted. I don't want to create an external link every time I run the macro?
VBA Copy / Paste Code:
ActiveWindow.ActivateNext
Application.DisplayAlerts = False
Selection.PasteSpecial Paste:=xlValues
Selection.PasteSpecial Paste:=xlFormats
Any help would be much appreciated.
Kindest Regards,
Chet
Is there a way to paste values and formats without the conditional formatting also being pasted. I don't want to create an external link every time I run the macro?
VBA Copy / Paste Code:
ActiveWindow.ActivateNext
Application.DisplayAlerts = False
Selection.PasteSpecial Paste:=xlValues
Selection.PasteSpecial Paste:=xlFormats
Any help would be much appreciated.
Kindest Regards,
Chet