Look in the object browser in Excel VBA.

--
Regards,
Tom Ogilvy

"Christopher Benson-Manica" wrote in message
...
Bob Phillips spoke thus:

For Each ws in Activeworkbook
For Each qyt In ws.QueryTables
qyt.Delete

I see. Now, if Excel's help could have told me that... I know now
that collections have a Count property, but where could I have found
that information, say, on MSDN or the VBA help...?

Next qty
Next ws

--
Christopher Benson-Manica | I *should* know what I'm talking about - if I
ataru(at)cyberspace.org | don't, I need to know. Flames welcome.