Hi all. What I am trying to do is, refresh a query on a different sheet in the same workbook. The code below will refresh on the same sheet, but is it possible to run a refresh from sheet1, that refreshes sheet2? Thanks Dan
Private Sub Refresh_Click()
Selection.QueryTable.REFRESH BackgroundQuery:=False
End Sub
Private Sub Refresh_Click()
Selection.QueryTable.REFRESH BackgroundQuery:=False
End Sub