Web query connection referencing a cell

http://www.excelforum.com/excel-prog...html?p=2822671

I am trying to do the same thing but using a web query. I need the macro to run a query that runs off of a url that is in a cell?? any ideas?
the url is going to change so I need cell being referenced. It would be really helpfull when reference the cell use the format Cells(1,1).Value because i would eventually like to use loops once this problem is solved thanks!!

Thank you for the help!!
but one more problem it does not seem to like the last line of code the ", Destination:=Range("$A$1"))" I got a syntax error, any ideas??

Please Login or Register  to view this content.

I got it thanks alot for your help.. for future info I had to make Cells(row,2).Value a variable and call it like

Please Login or Register  to view this content.

AHHH!! nevermind it does not work. for some reason both ways yours and mine it does not seem to grab the value in the cell. it just creates a blank worksheet