title: Need help fixing a vba Error '1004' after editing a section of code
body: <p>Some background, I've written a piece of code that cycles through all workbooks in a directory and executes a function, and that function also executes another function. Both functions tested fine and worked without an issue until I put them into the code that goes through all workbooks.
  I had this code originally and had no problems with it: </p>
  
  <pre><code>Set tbl = shtOfErrors.UsedRange
  tbl.Offset(2, 0).SpecialCells(2, 23).Select
  Selection.Resize(, 3).Select
  </code></pre>
  
  <p>I was trying to get rid of all .select I had in the original functions, because it kept erroring when it was called as part of the workbook loop. But now I get an error 1004 application-defined or object-defined error here on line 3 :</p>
  
  <pre><code>Set tbl = shtOfErrors.UsedRange
  Set selrng = tbl.Offset(2, 0).SpecialCells(2, 23)
  Set seltbl = selrng.Resize(, 3)
  </code></pre>