"Mike Fogleman" wrote:

I had the same problem with queries. The Temp sheet kept filling up with
references to old queries. Another problem could be in the way you clear the
Temp sheet. Excel remembers the "Used Range" of a sheet even though it
appears empty. Hit Ctrl+End on that sheet to find the lower right corner of
the Used Range. The answer to both problems is to not keep the Temp sheet.
Add the sheet to do your queries and delete it when you are through with it.

Thanks! I thought that Selection.ClearContents would do the same as delete,
but it seems that it leaves the references (etc) there.