title: Converting VBA to office Script please :-)
body: <p>I need to convert the following VBA I have on an excel sheet but I want to start using this online and would like to convert it to office script. any help as im not finding my way around this :-(</p>
  <pre><code>Sub Button1_Click()
    With Sheets(&quot;Input&quot;)
      .Range(&quot;A8&quot;, .Range(&quot;A8&quot;).End(xlDown).End(xlToRight)).Copy
    End With
    With Sheets(&quot;Data&quot;).ListObjects(1).Range
    .Cells(.Rows.Count + 1, 1).PasteSpecial xlValues
    End With
    Application.CutCopyMode = False
    With Sheets(&quot;Input&quot;)
      .Range(&quot;A8&quot;, .Range(&quot;A8&quot;).End(xlDown).End(xlToRight)).ClearContents
    End With
      End Sub
  </code></pre>
  <p>Is anyone able to help re-write this to work in excel scripts for web?</p>