XLL+ Class Library

CXlMacros::Border

Adds a border to the selected cell or range of cells

[C++]
static int Border(
   short int outline = -1,
   short int left = -1,
   short int right = -1,
   short int top = -1,
   short int bottom = -1,
   short int outline_color = -1,
   short int left_color = -1,
   short int right_color = -1,
   short int top_color = -1,
   short int bottom_color = -1
);

Parameters

outline

Outline is a number from 0 to 7 specifying the line style. A value of -1 is treated as a missing argument.

left

Left is a number from 0 to 7 specifying the line style. A value of -1 is treated as a missing argument.

right

Right is a number from 0 to 7 specifying the line style. A value of -1 is treated as a missing argument.

top

Top is a number from 0 to 7 specifying the line style. A value of -1 is treated as a missing argument.

bottom

Bottom is a number from 0 to 7 specifying the line style. A value of -1 is treated as a missing argument.

outline_color

A number from 1 to 56 corresponding to the Color box in the Border dialog box. Zero corresponds to automatic color. A value of -1 is treated as a missing argument.

left_color

A number from 1 to 56 corresponding to the Color box in the Border dialog box. Zero corresponds to automatic color. A value of -1 is treated as a missing argument.

right_color

A number from 1 to 56 corresponding to the Color box in the Border dialog box. Zero corresponds to automatic color. A value of -1 is treated as a missing argument.

top_color

A number from 1 to 56 corresponding to the Color box in the Border dialog box. Zero corresponds to automatic color. A value of -1 is treated as a missing argument.

bottom_color

A number from 1 to 56 corresponding to the Color box in the Border dialog box. Zero corresponds to automatic color. A value of -1 is treated as a missing argument.

Return value

Zero if the function has been called successfully; non-zero if the function could not be called. See Error codes for a list of return values.

Remarks

See the Microsoft Excel on-line Help for full details about this function.

Requirements

Header: xlfuncs.h

See Also

CXlMacros Class | CXlMacros Methods