is there any other way I can get around that? The range will always be constant to the workbook and macro.
Is it possible to do something like...
Dim RAW As ListObject
    Set RAW = ThisWorkbook.Sheets("Data").ListObjects("Table_owssvr_1")
would that work better or no different?
(I assume you are talking about the "ListObject" table.)