I have a query on a spreadsheet that grabs data from a
database on a corporate server. I can manipulate the
results of the query directly on the sheet, but I can't
use code to reference any of the cells. If I try to
select a cell in code, I get an error '1004' - Select
method of range class failed. Any ideas?

I guess there might be more ideas if you posted the code that's giving you a
problem

Regards

Trevor


"Reney Langlois" wrote in message
...
I have a query on a spreadsheet that grabs data from a
database on a corporate server. I can manipulate the
results of the query directly on the sheet, but I can't
use code to reference any of the cells. If I try to
select a cell in code, I get an error '1004' - Select
method of range class failed. Any ideas?

Can you give a sample of the code?

--


"Reney Langlois" wrote in message
...
I have a query on a spreadsheet that grabs data from a
database on a corporate server. I can manipulate the
results of the query directly on the sheet, but I can't
use code to reference any of the cells. If I try to
select a cell in code, I get an error '1004' - Select
method of range class failed. Any ideas?

As I was paging through some of the other postings,
someone gave the advice of using ActiveSheet.Range rather
than just Range.... I tried this and it worked. The new
code is below. I click a button from another sheet, the
embedded query is on the worksheet "Project". The
original code would crash when I tried to select cell A1
with the simple Range("a1").select command. The code
below works. I'm going to go with this for now.

Private Sub cmdUpdate_Click()

Worksheets("project").Select
ActiveSheet.Range("a1").Select
Selection.QueryTable.Refresh BackgroundQuery:=False

-----Original Message-----
Can you give a sample of the code?

--


"Reney Langlois"
wrote in message
...
I have a query on a spreadsheet that grabs data from a
database on a corporate server. I can manipulate the
results of the query directly on the sheet, but I can't
use code to reference any of the cells. If I try to
select a cell in code, I get an error '1004' - Select
method of range class failed. Any ideas?


.