Excel - macro or vb for deletion?

[Inquirerer]

Anyone know how to setup a command to auto delete a row in excel?

 

[JE McGimpsey]

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*

 

[Harald Staff]

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