View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Benz Benz is offline
external usenet poster
 
Posts: 63
Default Format Cell- Border Line

Thank You!!

"Jim Thomlinson" wrote:

Try this...

Sub RedDiagonal()
With ActiveCell.Borders(xlDiagonalUp)
.LineStyle = xlContinuous
.Weight = xlThick
.ColorIndex = 3
End With
End Sub
--
HTH...

Jim Thomlinson


"Benz" wrote:

I was hoping someone can help me figure out code that will format the
selected cell with a thick-diagonal red line through it.

Thank you to anyone who helps :)