tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
In excel, this is perfectly valid:
when entered as an ARRAY formula, using Ctrl+Shift+Enter.
Is it possible to use a similar syntax in VBA arrays?
For example:
I am getting a Type mismatch error.
Thanks
Rich (BB code):
=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:
Rich (BB code):
Dim FirstRng As Range
Set FirstRng=Range("C1:C100")
Dim SecondRng As Range
Set SecondRng=Range("D1:D100")
OutputArray(Counter, 1) = Application.WorksheetFunction.Match(1, (StartArray(Counter, 6) = FirstRng) * (StartArray(Counter, 7) = SecondRng), 0 )
I am getting a Type mismatch error.
Thanks
Last edited: