The cell that contains the CF rule I want to copy has got border format applied, so when using this:-
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.
Excel Formula:
PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False.
The only thing I can think of would be to delete the borders after the cells are pasted.