title: VBA Select command is causing my Macro to crash
body: <p>This macro was working for awhile and then suddenly stopped working.  whenever I attempt to run the macro now it immediately shuts excel down.  I commented out the entire macro and then ran it one line at a time until I found where it started crashing.  it's on this line:</p>
  
  <pre><code>Sub Run()
  '
  ' Run Macro
  '
  
  '
      Application.ScreenUpdating = False
  
       Sheets("Index").Select
  ...
  
  End Sub
  </code></pre>
  
  <p>Any suggestions?  i've read the .Select is bad but I don't have the coding skills to create a workaround.</p>
  
  <p>Thank you!</p>