Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a Micro that makes borders for certain range.
I would like to make this code better, because if you add extra row or delete a row this micro will not do its job right. The borders will always start at B31, but it can end anywhere. In B30 there always will be the word "Area" and after the last cell to do borders it will always be the word "Comments/Issues:". so can it be done with a "if" statement if the see those words or is there an other better way? This is the code. Sub FixBorders() ActiveSheet.Unprotect Password:="eli" Range("B31:O98").Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlDouble .Weight = xlThick .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlDouble .Weight = xlThick .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlHairline .ColorIndex = xlAutomatic End With With ActiveSheet .Protect Password:="eli" .EnableSelection = xlUnlockedCells End With End Sub Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Micro | Excel Worksheet Functions | |||
Question about borders | Excel Discussion (Misc queries) | |||
Question about Cell Borders | New Users to Excel | |||
Micro | Excel Worksheet Functions | |||
what does the micro do | New Users to Excel |