Search This Blog

Monday 29 July 2013


VBA Excel - Entering a Formula in a Cell
 
 


 


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



 

 


 

 

 

 

 

 

No comments:

Post a Comment