View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DennisS DennisS is offline
external usenet poster
 
Posts: 2
Default Is it possible to pass a parameter into IN operator in Query?

Hello all.
Is it possible to pass a parameter into Excel Query that uses IN operator.
Something like
IN([Param1])
where
Param1 refers to a cell in a worksheet and contains a list.

I tried to pass things like
A1=" 'first', 'second','third',..."
A1="first, second, third, ..."

nothing seems to work.
Thanks!