Category Archives for "Uncategorized"

Count cells without formulae

If you want to count cells in a given range without formulae use this function Function CountNoFormula(rng As Range) As LongDim c As Range   On Error GoTo CountNoFormula_Error    For Each c In rng        If Not c.HasFormula Then            CountNoFormula = CountNoFormula + 1        End If    Next cCountNoFormula_CleanUpExit:   Exit FunctionCountNoFormula_Error:    CountNoFormula = CVErr(Err.Number)    Resume CountNoFormula_CleanUpExitEnd Function If you want to count cells with formule […]

Continue reading