microsoft query and parameters from within excel 1

[mikecollett]

i am sure i am missing something basic here.

how do i point a microsoft query that for instance has an insertion starting point starting at cell a2 to look at cell a1 for its parameter.

cheers

Mike C

 

[PHV]

Right click in A2 and choose Parameters.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[mikecollett]

yes - that was it

thank you

i knew it would be simple

cheers

Mike C