In excel, this is perfectly valid:
=MATCH(1,F1=C1:C100)*(G1=D1:D100),0)
when entered as an ARRAY formula, using Ctrl+Shift+Enter.
Is it possible to use a similar syntax in VBA arrays?
For example:
Dim FirstRng As Range
Set FirstRng=Range("C1:C100")
Dim SecondRng As Range
Set...