Refresh Query by Name, not by Sheet().Range().QueryTable

**Whizbang** · 11-17-2009, 12:01 PM

I would like to refresh my queries by their names, rather than by

Please Login or Register  to view this content.

I would like it independent of the sheet and range. Something like

Please Login or Register  to view this content.

Is this possible?

**romperstomper** · 11-17-2009, 12:23 PM

No, it's not, I'm afraid. (you don't need the Range bit though).

**Whizbang** · 11-17-2009, 12:31 PM

Originally Posted by romperstomper

(you don't need the Range bit though).

Do you mind clarifying that? I can't seem to get it to work without some sort of cell reference.

**romperstomper** · 11-17-2009, 12:40 PM

Certainly - for example:

Please Login or Register  to view this content.

**Whizbang** · 11-17-2009, 12:55 PM

Ok. Thanks.

**Whizbang** · 11-17-2009, 04:59 PM

I found this:

http://www.vbforums.com/showthread.php?t=333048

The person seems to be using the syntax

Please Login or Register  to view this content.

They also seem to use an index

Please Login or Register  to view this content.

But I can't seem to get it to work at all.

Re: Refresh Query by Name, not by Sheet().Range().QueryTable