<< Click to Display Table of Contents >> Navigation:  Macros > Macro commands and parameters > Macro reporting commands > Macro write to Excel > Macro command Border

Purpose:

Create a border around the contents of a range of cells in the worksheet.

 

General notation:

Border ( FileIndex, sheet , row1 , column1 , row2 , column2 )

 

Series of cells can be addressed using row and column numbers. The values row1 and column1 refer to the top left-hand corner of a series, while row2 and column2 refer to the bottom right-hand corner. The normal Excel notation (identification of a cell by means of a combination of letters and numbers) is not possible because the macro language works on a numeric basis.