View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
tskogstrom tskogstrom is offline
external usenet poster
 
Posts: 92
Default What is fastest? "If .LineStyle < xlContinuous ..." or ".LineStyle = xlContinuous" ??

OK, now I understand, maybe ... ,

I tried this but didn't made it work. I used:

With rngForm.Borders(xlEdgeTop)
If .LineStyle < xlContinuous Then
.LineStyle = xlContinuous
End If
If .Weight < xlMedium Then
.Weight = xlMedium
End If
If .Color < RGB(255, 0, 0) Then
.Color = RGB(255, 0, 0)
End If
End With

.... but if rng had several border ranges, it passed by. But you use
IsNull(). That might make a different.

Kind regards
Tskogstrom