I have created an VSTO application and looking for something to set height of formula bar. This option is available for Excel 2007 but i am unable to find any such property which could help me out for 2003 version of excel.
Any help would be highly appreciated.
You can use the Resize command in Excel to add rows and columns to a table: Click anywhere in the table, and the Table Tools option appears. Click Design > Resize Table.
Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
The Application.FormulaBarHeight Property was added in Excel 2007 and is not available in earlier versions.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With