NativeExcel suite v1.x

Reference > IXLSRange > Borders

Borders property

Returns a IXLSBorders collection that represents the borders of a range of cells.

Syntax

property Borders: IXLSBorders;

Example

This example sets the color of the bottom border of cell B2 on sheet one to a thin red border.

With Workbook.Worksheets[1].Range['B2', 'B2'].Borders[xlEdgeBottom] do
begin
  LineStyle := xlContinuous;
  Weight := xlThin;
  ColorIndex := 3;
end;

Copyright © NikaSoft 2004-2010