Data Type Help

[NatalieEC]

Hi Everyone,

I am trying to get into the habit of using option explicit. Therefore, I have to declare each variable.

A piece of my script which will delete all query tables within a sheet. When I run my code, I get "Application-defined or object-defined error" message and it stops on this line:

Please Login or Register  to view this content.

Am I declaring the dest variable incorrectly as a range?

Please Login or Register  to view this content.

[MarvinP]

Hi Natalie,

I think you need to "fully qualify" your qt.Destination.

It might need Activesheet.qt.Destination or more qualifiers for the object to be fully determined.

https://msdn.microsoft.com/en-us/vba...e-object-excel

[xlnitwit]

Hi,

You would get a Type Mismatch error if the problem was with the variable type. If you view the Locals window while the code is in debug mode, what is shown for the qt.Destination property?

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[xlnitwit]

Try:

Please Login or Register  to view this content.

That won't work because it's not a named range. qt is a Querytable object and Destination is a property that returns a Range object.

[JOHN H. DAVIS]

@ xlnitwit - Thanks for the info. I never work with Querytable and didn't know.