I have a macro set up to copy paste "formats only" from one cell to a receiving cell. Is there a way I can copy all formats except the borders. I'm writing code to run a tournament and the bracket borders are being changed when ever I do the past/special formats option.

I have so many cells I have to change that it is impractical to set up conditional formatting.

Thanks for any help.