"keepITcool" wrote ...

your test leads to wrong conclusions.

you MUST reference the sheetname else you'll retrieve the data from the
sheet that was active when the file was saved.

keepITcool,
Sorry, your test also leads to wrong conclusions <g.

If you omit the sheet name e.g.

SELECT * FROM [A:A]

the worksheet queried will be the first i.e.
ThisWorkbook.Worksheets(1), even if it is hidden.

You can also omit the sheet name if you are using a workbook-level
defined Name, of course <g.

Jamie.

--