Delete rows with specific text in column

[danieldaniel1]

I found the following macro on another forum (unfortunately I do remember who posted it):

Please Login or Register  to view this content.

What i need help with is to also delete all rows with "(Physical Store)" in the same macro but it does not work for me.

Thanks in advance

[alansidman]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added them for you this time. Please read our rules and abide by them in the future.)

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[danieldaniel1]

Oh sorry. I'm a beginner in VBA and it is the first time for me posting. Thanks for the help!

[danieldaniel1]

What i need help with is a macro that deletes all rows with either (No risk) or (Physical store) in column B. As i mentioned before i found the following macro here but it only takes away one of them. I want both to be deleted.

Please Login or Register  to view this content.

[alansidman]

this worked for me on your file

I did need to change the sub routine name to make it all one string

Please Login or Register  to view this content.

[danieldaniel1]

Thank you very much alansidman. Appreciate it!