Why does this fail?
but this not?
Yes, SAP02 is the codenae for worksheet "SAPBEXqueries"
Code:
Dim QueryRange As Range
Set QueryRange = SAP02.Range("SAPBEXq0001")
but this not?
Code:
Dim QueryRange As Range
Set QueryRange = Range("SAPBEXqueries!SAPBEXq0001")
Yes, SAP02 is the codenae for worksheet "SAPBEXqueries"