424 Error: Coding on a web query workbook

[dzlash]

I am trying to select a range in a workbook that has a web query. The data I am trying to work with can be updated by refreshing. I have tried copying the range and special pasting just the values in another worksheet and selecting the range that way..I had no luck.

The code works on a non web query workbook.

I have simplified my code to just:

Sub A ()
Windows("AA" & ".xls").Activate
Sheets("Sheet1").Activate
Range("F44:Q44").Select
End Sub

I am receiving a 424 error (Object Required)

Thought? Thanks!