Select and Delete Multiple Rows based on Cell contents

The situation:

I have a number of .csv files in a specific folder. Let's say 10 files and I want to be able to open each file and look at the range of column "B"
If any cell after B3 within the range, EG. B7, B9 or B100 etc. does NOT = "Smash" then I want the entire row selected and deleted.
I don't want the data in that row to just be cleared, I want the row itself deleted.
Once all rows are checked and deleted, then the file will SAVE and go to the next .csv file.

PROGRESS:

I have the code to open all of the files and then save them once an operation has been performed.

WHAT I NEED ASSISTANCE WITH:
I need the code to look at each cell within the range and then select and delete the rows that do not = "Smash"
I have attached my current code that opens and saves along with the loop of previous code that performed a function and iterated through files. I know right where the new code should go and appreciate any help with the issue.
I have also attached an example spreadsheet with the code in a module.
In the spreadsheet example is Module 1, which has my original code that would open all .csv files in a folder and replace text in specific cells GI3, GJ3 and GK3 with "Percent."
I also have Module 2 that is the same code, but has the sections '........................ of where new code should go.
I have also attached example code.
Thanks in advance for the help!

Troy

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.

Could you post your enitre code? as that should not be happening.

Thanks for the help.

Please Login or Register  to view this content.

That works for me, although this line

Please Login or Register  to view this content.

should probably be within the loop.
Can you upload one of the csv files that is causing problems?

I have the code working. Thanks for your help Fluff13!

Here is the final code:

Please Login or Register  to view this content.

Glad you got it sorted & thanks for the feedback

First off. Thanks!

The code works fast. I did have an issue that we overcame and I tell you this just as an FYI.

Though I used "Smash" as my word to compare, in reality the strings I am using are different. E.G. F2R3 or R3F4 and other combinations.
I initially used F2R3 and the macro worked perfectly on all of the files.
Next, I tried R3F4 and the macro kept erroring out.
What we found was, for some reason, excel does not like the first character to be an "R" followed by a single digit number.
Our solution is to use "fR3F4" and the code works perfectly again, as it ignores the extra character in our solution.
Just thought I would let you know of the weird occurrence.

Here's the new code:

Please Login or Register  to view this content.

Additionally, we refined the code more, so I only needed to change one string for my changes!

Please Login or Register  to view this content.

Many thanks for the feedback.

The reason you had problems with R3F4, is that when you put an = sign in front xl thinks you are using an R1C1 reference.
But as =R3F4 is not a valid reference it causes problems.

Will you be doing multiple replaces on each file?