Entire Row Delete

[stapuff]

I am looking to delete a row only if the row number is double clicked.

The following works, however, not specifically what I am looking for.

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
With Target.EntireRow.Delete
End With
End Sub


Any thoughts...

Thanks,

Kurt

 

[Norie]

Kurt

Do you mean the row number to the left of the actual sheet?

If so then I don't think there's any event associated with it.

What specifically do you want to do?

By the way the code posted is for the BeforeRightClick event.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.EntireRow.Delete
End Sub

 

[Oaktree]

Maybe:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
If (Target.Count = 256 And Target.Rows.Count = 1) Then Target.EntireRow.Delete
End Sub

 

[Von Pookie]

Would this work for you?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Application.EnableEvents = False
If Target.Columns.Count = 256 Then Target.EntireRow.Delete
Application.EnableEvents = True

End Sub

If you click the row number, the entire <strike>column</strike> row (not column, duh) is selected. So if the number of columns in the selection=256, delete the selected row(s).

 

[stapuff]

Norie -

Yes - I am looking for the row number left of the sheet.

Thanks,

Kurt

 

[stapuff]

Von Pookie -

That was exactly what I wanted.

I appreciate everyone that took the time to look at the post and for those who gave suggestion my hat is off to you.

Thanks for your time and energy,

Kurt