View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_2_] Robert Crandal[_2_] is offline
external usenet poster
 
Posts: 158
Default Delete a row that is double clicked

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?