AutoFitColumns Method Example

This example changes the row height and column width in the range A1:B5 on the spreadsheet to achieve the best fit for the data in range.

Spreadsheet1.Range("a1:b5").AutoFitColumns
Spreadsheet1.Range("a1:b5").AutoFitRows