Adding Parameters to an Excel Query (NOT Power Query)

[SkipVought]

WHERE [Start Date] >=?
AND [End Date] <?

When you Return data to Excel, you will be able to control the way that the Parameters are entered. As I recall there are 3 options including to specify the CELL(s) that the data resides.

Right-click in the QueryTable results and Select Table from Drop Down.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein