AutoFitRows 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