Dear all,
I am running a loop which copies a row of cells and then pastes them as values, formats and no borders.
The bordes keep appearing and the VBA code am using is as follows:
Range("RLV_COPY").Copy
Range([RLV_DESTINATION]).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteAllExceptBorders, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Anyone can shed some light?
Thanks John
Bookmarks