T
Tangier
Hi,
I am trying implement an Ad Hoc query in the VB editor that looks like
this:
SELECT (the fields I want)
WHERE IDs In (take parameters)
Now my problem is, how do I tell Excel to take the range of data
between F2 and F55 and use these in the where, or as criteria? I
tried :
WHERE ChildID IN ( &Range(F2:F55)& ) but stuck out.
Can anyone tell me the syntax? THANK YOU!
I am trying implement an Ad Hoc query in the VB editor that looks like
this:
SELECT (the fields I want)
WHERE IDs In (take parameters)
Now my problem is, how do I tell Excel to take the range of data
between F2 and F55 and use these in the where, or as criteria? I
tried :
WHERE ChildID IN ( &Range(F2:F55)& ) but stuck out.
Can anyone tell me the syntax? THANK YOU!