ExcelBanter - Cell border

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cell border (https://www.excelbanter.com/excel-worksheet-functions/120363-cell-border.html)

[email protected]

Cell border

What's the method for Cell Border in the code module.

Bob Phillips

Cell border

rng.Borders(xlEdgeBottom)

where the border can be xlDiagonalDown, xlDiagonalUp, xlEdgeBottom,
xlEdgeLeft, xlEdgeRight, xlEdgeTop, xlInsideHorizontal, or xlInsideVertical.

Look at Border Object in VBA help.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
ps.com...
What's the method for Cell Border in the code module.

All times are GMT +1. The time now is 11:11 AM.