I have been trying to piece together some script to remove vertical borders for a row if there is no data in the first column for that row. Following is the script I have so far:
'Remove Border for totals
Dim rngToChange As Range
Dim C As Range
Set rngToChange = ActiveSheet.Range("A2:H" & LR)
For Each C In rngToChange
If IsEmpty(C) Then
C.Borders(xlDiagonalDown).LineStyle = xlNone
C.Borders(xlDiagonalUp).LineStyle = xlNone
C.Borders(xlEdgeLeft).LineStyle = xlNone
C.Borders(xlEdgeRight).LineStyle = xlNone
Else
End If
Next
Any help in resolving would be appreciated.
Thanks,
Met
Bookmarks