title: Run-time error '1004' ShowAllData method of Worksheets class failed
body: <p>Iam getting confused. Can someone try to explain this for me.
  Below is a part of recorded macro im using. Sometimes it runs with no error while 10 minutes later ill get the error message in the Title field, and it stops at the LAST ActiveSheet.ShowAllData</p>
  
  <p>It so unlogical for mer but probably there is an explanation to this.
  Im always in the same sheet when activating the macro..</p>
  
  <pre><code>Sheets("DB2 Totbel").Select
      ActiveSheet.ShowAllData
      Sheets("DB2 Giva").Select
      ActiveSheet.ShowAllData
      Sheets("TS4LAGER").Select
      ActiveSheet.ShowAllData
      Sheets("PIX").Select
      ActiveWorkbook.Worksheets("PIX").ListObjects("Table_Query_from_DB2W").Sort. _
          SortFields.Clear
      Sheets("OFO data").Select
      ActiveSheet.ShowAllData
      Sheets("Arbetsyta").Select
      **ActiveSheet.ShowAllData**
  </code></pre>