Similar to the CellBorder method, but allows the user to specify the range instead of using the selection CellBorderRange.
Sub CellBorderRange(Row1 As Long, Col1 As Long, Row2 As Long, Col2 As Long, Color As OLE_COLOR, Left As Integer, Top As Integer, Right As Integer, Bottom As Integer, Vertical As Integer, Horizontal As Integer)
The parameters for the CellBorderRange method are described below:
Row1, Col1, Row2, Col2 As Long
These parameters specify the range where the border will be applied.
This parameter determines the color of the border.
Left, Top, Right, Bottom As Integer
These parameters specify the width, in pixels, of the border to be drawn around the selection. Specify zero to remove the border, or any negative number to preserve the existing border.
Vertical, Horizontal As Integer
These parameters specify the width, in pixels, of the borders to be drawn inside the selection in the vertical and horizontal directions. Specify zero to remove the border, or any negative number to preserve the existing border.