I have a routine that runs a sql query for each cell in the range. I am running three different instances of it for 3 different ranges.The first two instances have simple sql queries and work fine (no variables declared)
The third instance uses a more complex query and I get an error:
Run-time error '3704':
Operation is not allowed when the object is closed.
Has anyone got any pointers on how to get to the bottom of the cause here.
The routine is below:
Please Login or Register to view this content.
Bookmarks