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