Copy ONLY Conditional Formatting rule with NO other cell formatting

[julhs]

The cell that contains the CF rule I want to copy has got border format applied, so when using this:-

PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False.

the border format is also copied, is there a way to prevent this.
The only thing I can think of would be to delete the borders after the cells are pasted.

 

[severynm]

Try changing your paste type to xlPasteAllExceptBorders. Source: XlPasteType enumeration (Excel)

 

[julhs]

Thanks senerynm.
Had consider this thread to be dead.
I ended up going down the route of removing the borders of the copy/ pasted cells.
Not tested what you gave but it would save the need for an extra line of code to remove the borders.

 

[julhs]

Have tried what you suggested; but Conditional Format rules didn’t get copied, just the value in the cell and its formatting.
This is what I had come up with and it works for me, it copies the Conditional Format rules but then has to delete the copied borders (line style).

CFcell.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
CFcell.Borders.LineStyle = xlNone

Very speculative, but just wondering whether me having applying the borders using “Line Style” from the “Draw Borders” collection and not the “Borders” collection is why your suggestion didn’t work for me??