Quote Originally Posted by dzugel
The strange thing is that it now works most of the time. But once a problem develops I must shut down Excel and restart before I can try to run the macro again. Does Excel keep a connection open if this kind of error is found during processing so that the macro cannot be rerun until Excel is closed? Any idea why it seems to be working now even though the only changes to the macro are the DEBUG.PRINT lines and moving the REFRESH statement to a separate WITH statement? Confused, but not so frustrated, in Atlanta.
i think you might have answered yourself here...excel's thinking is your friend or enemy...you will encounter this with formattimg in cells...like date stuff...here BACKUP YOUR WORK....THEN [QueryTable.Delete] or try your macro on a new sheet , workbook, whatever... i think by hand you select all cells then delete...you get a message if ya wanna bla bla...kill it all... now retry.. lemme know...there is now doubt there is a way to to get yur stuff on yur sheet