What would I use to test if the top of a cell has a border?
What would I use to test if the top of a cell has a border?
yawnzzzz,
Please try to be more descriptive with your titles as per forum rules below
VBA Noob![]()
Sub TestForBorder() Dim c As Range For Each c In Selection If c.Borders(xlEdgeTop).LineStyle = xlContinuous Then MsgBox c.Address(0, 0) End If Next End Sub
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks