J
jt
i wish to count cells in a range that have diagonal cell borders or
the cell is X'd out, is it possible, thanks for any help
the cell is X'd out, is it possible, thanks for any help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
lifescholar
i wish to count cells in a range that have diagonal cell borders or
the cell is X'd out, is it possible, thanks for any help
Try the following UDF:
Function CountDiagonal(rng As Range)
Dim i As Integer
Dim cell As Range
i = 0
For Each cell In rng
If cell.Borders(xlDiagonalDown).LineStyle <> xlLineStyleNone _
Or cell.Borders(xlDiagonalUp).LineStyle <> xlLineStyleNone
Then
i = i + 1
End If
Next
CountDiagonal = i
End Function
G
Gord
What do you mean by "X'd out"?
Post an example.
Gord Dibben Microsoft Excel MVP
Post an example.
Gord Dibben Microsoft Excel MVP
J
jt
What do you mean by "X'd out"?
Post an example.
Gord Dibben MicrosoftExcelMVP
- Show quoted text -
excellent, this works, thankyou