Testing for a Border Property in Excel

[dawa1234]

Here's what I need to do. I need to be able to test for a border property in excel using VBA. I have the top, bottom and two borders on each cell and some cells had the diagonal up and the diagonal down borders. I need to test for the diagonal borders. Any ideas?

i've tried
If Selection.Borders = xlDiaganolUp
If Selection.Borders(xlDiagonalUp) = True
but they don't work, so I know I must be missing something.

Thanks in advance.

dawa1234

 

[sfvb]

Here's an example:

If Selection.Borders(xlDiagonalDown).LineStyle <> xlLineStyleNone Then
MsgBox &quot;Found one&quot;
End If

 

[dawa1234]

Well that seemed to do the trick.
Thanks again.