excel:macro_search_sequentially
This is an old revision of the document!
Excel - Macro Search Sequentially
' 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
excel/macro_search_sequentially.1468225298.txt.gz ยท Last modified: 2020/07/15 09:30 (external edit)