Differences

This shows you the differences between two versions of the page.

--- excel:macro_search_sequentially [2016/07/11 08:21] – created peter
+++ excel:macro_search_sequentially [2016/07/11 11:30] (current) – removed peter
@@ Line 1: / Line 1: @@
-====== Excel - Macro Search Sequentially ======
-<code excel>
-' Returns the number of vCrit found within the array oArrWithCrit.
-Function ArrayCountIfSequential(oArrWithCrit As Variant, vCrit As Variant)
-    Dim lRow As Long
-    For lRow = LBound(oArrWithCrit, 1) To UBound(oArrWithCrit, 1)
-        If oArrWithCrit(lRow, 1) = vCrit Then
-            ArrayCountIfSequential = ArrayCountIf + 1
-        End If
-    Next
-End Function
-</code>