Delete Entire Row based on Selection

I have a worksheet where I have restricted the users from scrolling around beyond a certain range.
Because of that the user is prevented from selecting an entire row.
There are some cases where the user should be able to delete entire row or range of rows.

How can I allow them to select say cells "C17:C35" [they would just hoghlight the range] and hit ctrl+d; which would trigger a macro and the macro in turn would delete all the rows in that selection [rows 17 through 35]?

I know some basic codes for deleting entire rows, but I don't know how to read first and last row of the selection under Target property.

Thanks,
modytrane

Hi Modytrane,

The following line of code will delete all rows that are currently selected:

Please Login or Register  to view this content.

You may need to unprotect the sheet first, then re-protect it afterwards if you have that turned on.

Please Login or Register  to view this content.

Along with that, if this macro already exists, do this to add the keyboard shortcut:

Press Alt-F8
Highlight the Macro in the list
Click on Options