PasteSpecial

[vbaNewby]

I am using pasteSpecial to copy from one worksheet to another.

Range("A1").PasteSpecial Paste:=xlPasteValues

The range I copy has borders. These borders are carrying over to my range("A1") on my other sheet.

I do not want that. I thought xlPasteValues does not carry over borders?

 

[vbaNewby]

I've tried:

[COLOR=blue] Paste:=xlPasteAllExceptBorders[/COLOR]

Still pasting borders? Strange.
<table width="1217" border="0" cellpadding="0" cellspacing="0"><col width="21" span="5"><col width="216"><col width="64" span="14"><tr height="20"> <td style="height: 15pt; width: 16pt;" width="21" height="20">
</td> <td style="width: 16pt;" width="21">
</td> <td style="width: 16pt;" width="21">
</td> <td style="width: 16pt;" width="21">
</td> <td style="width: 16pt;" width="21">
</td> <td style="width: 162pt;" width="216">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> </tr></table>

 

[vbaNewby]

Silly me, I had another paste below the code that was overriding it. Disregard please.