title: How to convert VBA into Javascript in order to upload Excel Macro-enable workbook on Google Drive?
body: <p>I would like to upload an Excel Macro-enable workbook on Google Drive but Google didn't support this file. They suggest me that I should convert VBA into Javascript and use Script Editỏ. I would like to convert this functionality in javascript, but I don't know where it is wrong. Can you give me a help?</p>
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
     If Target.Cells.Count &gt; 1 Then Exit Sub
  
     If Not Intersect(Target, Range(&quot;A2:A100&quot;)) Is Nothing Then
        With Target(1, 2)
           .Value = Date
           .EntireColumn.AutoFit
        End With
     End If
  End Sub
  </code></pre>
  <p>Javascript conversion attempt:</p>
  <p><img src="https://i.stack.imgur.com/IxchX.png" alt="converted code" /></p>