ExcelBanter - Rightborder

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Rightborder (https://www.excelbanter.com/excel-programming/415678-rightborder.html)

PdeC

Rightborder

How can I determine if a cell has a right border or not ?
Thanks for a code.

Don Guillett

Rightborder

try this one liner
Sub ifrightborder()
If ActiveCell.Borders(xlEdgeRight).LineStyle _
< xlLineStyleNone Then MsgBox "Hi"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PdeC" wrote in message
...
How can I determine if a cell has a right border or not ?
Thanks for a code.

All times are GMT +1. The time now is 09:58 PM.