Rightborder

  • Thread starter Thread starter PdeC
  • Start date Start date
P

PdeC

How can I determine if a cell has a right border or not ?
Thanks for a code.
 
try this one liner
Sub ifrightborder()
If ActiveCell.Borders(xlEdgeRight).LineStyle _
<> xlLineStyleNone Then MsgBox "Hi"
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Border formatting row of cells 22
Borders around cells with data in them 5
1004 Error: Unable to set the LineStyle property of the Border class 1
Problem setting BorderArround LineStyle:=xlLineStyleNone 3
Borders Disappear When Hiding Columns 2
Insert Border 2
toggle borders 4

Back
Top