Paste Borders ONLY?

[Gregg Wolin]

Is there a way to copy and paste ONLY the borders from a range to another WITHOUT DISTURBING other formats (including conditional formats)? I found a VBA macro that does it - but it wipes out the other formats in the process.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[Marc L]

No in older Excel versions but
just check PasteSpecial method in VBA inner help …

If negative,
you must read all source borders and reproduce them to destination …

Or you just save the destination number format before pasting
and reapply this saved format after the pasting …
​