Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Clearing a range differs from deleting a range When you delete a range, Excel shifts the remaining cells around to fill up the range
Sub delete()
    Rows("6:6").delete
End Sub