Can you paste special column borders only?

[Milos]

Hi all,

I have been successfully Paste Special(ing) values into another workbook using this code:

With Selection
.PasteSpecial Paste:=xlPasteValues
End With

However as I am anal retentive and I like everything to look perfect I am wanting to Paste special the borders without any of the other formats (i.e. formulas etc). Is this able to be coded alongside the paste special values?

Any help is greatly appreciated!

Thanks,

 

[oldbrewer]

A1=B1+C1 paste special values A1 to D1 clearly pastes the VALUE from A1

providing D1 was previously given a border the border will remain

if D1 is empty and borderless use this conditional formatting in D1and apply border if true =D1<>""

 

[steve the fish]

You can use .PasteSpecial xlPasteFormats which pastes formatting without pasting formulas.