Query Sheet using a WHERE clause?
 

Using ADO I can:

SELECT * from [Sheet1$A1:B50]

and get the lot... but I just what the row that has A$="Blah" and

SELECT * FROM [Sheet1$A1:B50] WHERE A$='Blah'

does not work.. and was wondering if anyone here has come across thi
before and might have a solution?

Thank

--
Message posted from http://www.ExcelForum.com

Query Sheet using a WHERE clause?
 

nm.. I found a solution :)


---
Message posted from http://www.ExcelForum.com/