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