working on it ...


Explore Public Snippets

Sort by

Found 1 snippet matching: "use excel formulas in vba"

    public by fabio.nosenzo  2817  0  5  0

    Use MS Excel formulas in VBA

    General description of vba excel formula insertion
    ' general description
    ' Application.formulaname(formula parameters)
    ' example
    ' count cells with value = x
    Dim iCounter As Integer
    iCounter = Application.CountIf(Range("A1:D5"), "x")

    List Complete ( 1 snippet total )

    Cannot find what you were looking for?
    Ask the Snip2Code Community

    • Public Snippets
    • Channels Snippets