Did you check VBA help for "QueryTables"?
Under Methods, select ADD and see the examples for QueryTables.

Does that help?

Post back with more questions.

***********
Regards,
Ron

XL2002, WinXP


"Neily" wrote:

Does anyone know how to use VB to create a QueryTable on a blank sheet?

The only way I'm able to create one is by using Data/Import External Data
command and querying a database.

Any ideas?