I've been trying to retrieve the number of borders a cell has using:

selection.Borders.Value

which gives the following results:
  • if the cell has no border you get -4142
  • if the cell has a complete border (4 lines) you get 1
  • if the cell has from 1 to 3 lines you get Null


How can I identify if the cell only has, for example, one upper border and one left border? etc...