for each myvariable in mylist
=" & myvariable
next

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
I have a macro I wrote that executes 4 queries to an ODBC Database.
Each query runs on different table in the database but uses the same
search criteria. How can I pass the saved variables to the 4 queries
so the user doesn't have to enter them 4 times.

Thanks for the help