help with macro code

[scottatbuckman]

I have the code below. However I would like to make it delete the cell values only, because I have list boxes in some of the cells. So when I run the code right now, it gets rid of the rows that have the yes selected, however, the cells that take the place no longer have my selection lists, they are just blank cells. Also, I do not need the code to move the deleted cells to the Completed Sheet. They can just be deleted for good. Thanks so much for any help!

Please Login or Register  to view this content.

[TMS]

Try ClearContents instead of Delete


Regards, TMS

[scottatbuckman]

That worked. Thanks much!

[TMS]

You're welcome. Thanks for the rep.

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.