Evaluate Named Range Array formula to VBA Array

Hi,

I have not been able to solve this. Does anyone know if it is possible to Evaluate a named range array operation into a VBA array. I can only populate the first value of the array operation.

Names.Add "Selector", RefersTo:="=--ISNUMBER(MATCH(TempTESTS,SelectedTESTS,0))*--ISNUMBER(MATCH(TempLSAC,SelectedLSAC,0))*--ISNUMBER(MATCH(TempSECTION,SelectedSECTIONS,0))"

Dim Selections As Variant
    
    Selections = WorksheetFunction.Transpose([Selector])