101Excel Hacks
    Back to Blog
    Excel VBA macrosHack 28
    =AVERAGE FUNCTION
    Excel formulas
    excel vba

    How to Insert Excel Formulas into Cells Using VBA (Range.Value)

    Excel Hack #28

    11 views
    1 min read
    2018-01-09
    How to Insert Excel Formulas into Cells Using VBA (Range.Value)

    To place a formula in a cell using Excel VBA, use the following code:   Sub VBAFormula() Range("A3").Value = "=AVERAGE(A1:A2)" End Sub

    To place a formula in a cell using Excel VBA, use the following code:  
    Sub VBAFormula() Range("A3").Value = "=AVERAGE(A1:A2)" End Sub

    Frequently Asked Questions