Thanks for the response here. Unfortunately this is not working for me and I’m trying to understand what you’re doing here so I can maybe modify it for my particular needs but I’m having no luck here. Basically what I need to do is this. After I select several rows in a sheet (they will all be grouped together if that matters) I run a macro that deletes any rows in that those selected rows that has a blank cell in column C. I can figure this out for doing the whole sheet or a predetermined range but I want the range to be whatever rows I select before running the macro. Thanks