Try the Formula property or FormulaR1C1 property (check out Help for explanations on how to use them). ... 'Select the cell on which you want to put formula
www.mrexcel.com