Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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