Thanks for any help.
I have some sheets in a workbook, with 5 querys each. I want to make a macro
that updates them, and I was going to do a activesheet.querytables.count, and
then do a for loop to refresh each one. But there is more than 5 querytables
on most of the pages. I think that is because when I first started doing this
kind of stuff, I deleted some or copied etc. How can I "find" the other
querytables so as to delete them?
Thanks again.