Greetings all. I recorded some putting a bold line around a range, and I am
using it for around 20 or so ranges in a macro. The recorded lines are
below...


With CurrentRange
' .Borders(xlEdgeLeft).LineStyle = xlContinuous
.Borders(xlEdgeLeft).Weight = xlMedium
' .Borders(xlEdgeLeft).ColorIndex = xlAutomatic
' .Borders(xlEdgeTop).LineStyle = xlContinuous
.Borders(xlEdgeTop).Weight = xlMedium
' .Borders(xlEdgeTop).ColorIndex = xlAutomatic
' .Borders(xlEdgeBottom).LineStyle = xlContinuous
.Borders(xlEdgeBottom).Weight = xlMedium
' .Borders(xlEdgeBottom).ColorIndex = xlAutomatic
' .Borders(xlEdgeRight).LineStyle = xlContinuous
.Borders(xlEdgeRight).Weight = xlMedium
' .Borders(xlEdgeRight).ColorIndex = xlAutomatic
End With

My question is, with this having to be in my macro so many times, I am
trying to shrink it down some. I commented out all but the .weight lines,
and for all appearances, the borders look the same with or without the
commented out lines running. I am using XL 2007. What could potentially go
wrong if I do not include them in the macro? Thank you.

Greg