VBA Excel - Entering a Formula in a Cell

 

 

http://www.java2s.com/Code/VBA-Excel-Access-Word/Excel/EnteringaFormulainaCell.htm

 

'Enters the formula =SUM($G$12:$G$22) in the active cell: Sub fomula()     ActiveCell.Formula = "=SUM($G$12:$G$22)" End Sub

 

 

Ssee also:   http://www.java2s.com/Code/VBA-Excel-Access-Word/CatalogVBA-Excel-Access-Word.htm