Delete a row that is double clicked

[Robert Crandal]

What is a quick and fast way to delete a row that is
double clicked by the user?

I know I must handle the Worksheet_BeforeDoubleClick()
function and the "Target" parameter. What comes next?

Using Excel's "Record Macro" function, it generated the
following code to delete a row: (Row 12 was clicked here)

Rows("12:12").Select
Selection.Delete Shift:=xlUp

I need to somehow incorporate the "Target" parameter into
the Rows object, right?

 

[Claus Busch]

Hi Robert,

Am Tue, 9 Apr 2013 03:13:43 -0700 schrieb Robert Crandal:

Rows("12:12").Select

try:
Target.EntireRow.Delete


Regards
Claus Busch

 

[Robert Crandal]

try:
Target.EntireRow.Delete

Awesome! I like that better than the code that Excel's
"Record Macro" function generates. Thanks!