can I use an array formula to query a source data table?
 

Is it possible to use an array formula to query an excel source data table?

How would the criteria work?
--
Please contact me by email if you have an answer to this question. I
appreciate it.

can I use an array formula to query a source data table?
 

I'm not sure but instead you can open the access opbject to get the data.

Set obj = CreateObject("Access.application")
obj.Visible = True
Set myDB = obj.Open(Filename:="c:\temp\myDB.mdb")

"TAD from DBL" wrote:

Is it possible to use an array formula to query an excel source data table?

How would the criteria work?
--
Please contact me by email if you have an answer to this question. I
appreciate it.