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

Purpose:

To fit the column width to the contents of a range of cells in the worksheet.

 

General notation:

Fit ( 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.