FSt1,
I tried your suggestion & recieved a Run-time error 1004
sheets("sheet1").range("A1").querytable.refresh backgroundquery:=false
I recorded the following with the macro recorder. But when I copy it into
my code, I still get a Run-time error 1004. I'm trying to run in a
cboBox1_Change sub located on Sheet3 that runs a refresh code to ReQuery
inbound data for a ListFillRange for cboBox2, then Enables cboBox2.
Sheets("Sheet2").Select
Range("A1").Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
I was able to get this code to work. However when I hide the query sheet2,
I get the Run-time error 1004. How do I refresh a single Hidden QueryTable?
I tried the following, but get a Run-time error 438.
With Sheets("Sheet2").Select
.querytable.refresh backgroundquery:=false
End With