ExcelBanter - SQL statement slower when refering to cells.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - SQL statement slower when refering to cells. (https://www.excelbanter.com/excel-programming/329753-sql-statement-slower-when-refering-cells.html)

John

SQL statement slower when refering to cells.

I have a long sql statement that refers to cells to use as parameters. The
query takes about 20 secs to run if I refer to the cells. For example I'm
refering to cell [C3] for the YEAR parameter. If I hard code the year into
the sql statement it takes about 2 secs to run. Any ways around this?
TIA... John..

All times are GMT +1. The time now is 04:59 PM.