Workbook.Sheets[1].Range['A1', 'C5'].Borders.Weight can be one of these XlBorderWeight constants := Example;