Ad Hoc Reporting

T

Tangier

Hi,

I am putting together an ad hoc report in Excel. My query is in the VB
editor. I am trying to specify criteria

Select x,y,z where...

in the WHERE, I am struggling.

I want to take a range of ids specified in the worksheet, F2:F55.

So

Select x, y, z where IDs IN ( F2:F55 )

I tried to use WHERE IN ( Range(F2:F55) ) but it did not like it.

What syntax should I use to make this work? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ad Hoc Reporting 0
Feeding Worksheet Data Into a Query 6
Countif, index and match 2
Macro for comparing columns and highlighting matching/differences 13
find exact data in cell 2
Number series at end of column macro? 4
Chart x axis Col A, Y axis Col b 0
Problem sorting a range of columns using VBA 1

Top