On previous post, I've explained how to delete cells shift to left and up, now i will explain how to delete entire row or entire column:
To delete entire row:
Sub deleteShiftLeft()
Thisworkbook.Activesheet.Range("B10").EntireRow.Delete
End Sub
To delete entire column:
Sub deleteShiftUp()
Thisworkbook.Activesheet.Range("B10").EntireColumn.Delete
End Sub
That's all. Fin.
No comments:
Post a Comment