Gary



Are you saying that I can place the cursor and then use the Refresh
method to get new data without creating a new named range?

No, it sounds like you need to create query tables and whenever you do it
will create a name. I don't think there's anyway to prevent that, so you'll
have to use Steve's suggestion and delete the extraneous ones.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.


"Dick Kusleika" wrote in
:

Gary

You probably don't need to create a new QueryTable every time. Create
the QueryTable once then use

Sheet1.QueryTables(1).Refresh

to update the data. If you need to change the QT every time, you can
do that also without deleting and recreating it.