Formula Property Example

This example sets the formula, column width, and number format for the range A1:F10 on the active worksheet.

Set rg = Spreadsheet1.ActiveSheet.Range("a1:f10")
rg.Formula = "=5*rand()"
rg.ColumnWidth = 100
rg.NumberFormat = "#.###"