Cell Select - Delete Entire Row

[zimbo109]

Hi, the simple following code allows me to delete items in a protected sheet. However what I want it to do is delete the entire row, as shifting the cells up causes problems with formulas moving. I am unable to select the row as I have protected against users being able to select locked cells. Is there anyway to adapt the code to "selection, delete entire row.?

Thanks
Chris

Please Login or Register  to view this content.

[sweep]

Does this help?

Please Login or Register  to view this content.

[zimbo109]

Yes it does- thank you, however is there a way in which I can delete the entire row of selection and include the next 10 rows?
Regards
Chris

[sweep]

Yes,

To delete the selected rows, plus the next 10 rows:

Please Login or Register  to view this content.

[zimbo109]

Thank you Sweep.

Regards
Chris