I'd still keep an eye out for problems.

(But I've had the same thing happen to me. I don't usually blame excel -- I
just figured that I made a change that I thought was insignificant and it
wasn't!)

wrote:

Weird - I commented out some code and the problem went away. Then I
started restoring the code in sections until, testing each time.

Finally I uncommented all the code and the error was still gone even though
the restored code that worked was 100 % identical to the code that
previously failed.

On Fri, 28 May 2010 10:47:04 -0400, wrote:

Oops - I should have mentioned that the worksheet was just created, so
there are no already existing queries.

--

Dave Peterson