title: Change Border Color of a Range Without Changing the Linestyle/Weight
body: <p>I have a nicely formatted range of cells with different border line weights (some of them are medium thickness and some of them are thin, in no particular pattern). I want to run a macro that changes the color of the borders to grey, but every time I do it, it changes all of the border weights to xlThin automatically. I want to keep the original line thickness so I don't have to go through and change the respective ones back to xlMedium, which would be tedious.</p>
  
  <p>Can someone help me out? Is this possible?</p>
  
  <p>The code I currently have is simple, and it changes the color correctly. It just also changes the line weight automatically, even though I don't specify the weight or linestyle at all: 
  <code>Range("NamedRange").Borders.Color = RGB(150, 150, 150)</code></p>