title: Run-Time error '1004' Application-defined or object-defined error
body: <p>(im aware of selection has to be avoided, im learning and has got help with other issues that are close related)
  Would be very thankful on help on how to re-code below to be more "broad" and as it is now it sometimes runs througt and sometimes not.</p>
  
  <p>It now stops on the fourth line with error message written in title.
  Keep in mind:
  As you can see, the recorded macro when refreshing databases gives two different types of code, i guess it has to be with my databases are copied when running through different excelversions??? Can it be written in one way? 
  A public sub that i can call?</p>
  
  <pre><code>    Sheets("DB2 Totbel").Select
      Selection.QueryTable.Refresh BackgroundQuery:=False
      Sheets("DB2 Giva").Select
      Selection.QueryTable.Refresh BackgroundQuery:=False
      Sheets("TS4LAGER").Select
      Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
      Sheets("PIX").Select
      Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
      'Sheets("PIX").Select
      'Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
      Sheets("OFO data").Select
      Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
  </code></pre>