title: Autofilter (Excel VBA to Google Spreadsheet)
body: <p>I have an excel spreadsheet with the following piece of code. I want to convert and upload this spreadsheet to a google drive spreadsheet. Can anyone help me with converting the VBA code to google apps script? Thanks!</p>
  
  <pre><code>Sub Filter1()
  
  'Assigned to Keyboard Shortcut Ctrl + Q
  ActiveSheet.AutoFilterMode = False 'Initializes the Filter
  ActiveSheet.Range("$D$2:$AZ$500").AutoFilter Field:=ActiveCell.Column - 3, Criteria1:="&lt;&gt;" 'Applies filter and criteria (blanks)
  
  End Sub
  </code></pre>