Anyone know how to setup a command to auto delete a row in excel?
J JE McGimpsey Sep 8, 2005 #2 Just any row? Based on a cell value? time? randomly? You can find thousands upon thousands of examples in the archives: http://groups.google.com/advanced_group_search?as_ugroup=*excel*
Just any row? Based on a cell value? time? randomly? You can find thousands upon thousands of examples in the archives: http://groups.google.com/advanced_group_search?as_ugroup=*excel*
H Harald Staff Sep 9, 2005 #3 Rightclick the sheet tab, choose "view code", paste this in: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target(1).EntireRow.Delete End Sub Now any row you select in that sheet will be deleted. HTH. Best wishes Harald
Rightclick the sheet tab, choose "view code", paste this in: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target(1).EntireRow.Delete End Sub Now any row you select in that sheet will be deleted. HTH. Best wishes Harald
