Please help with row deletion

[bkbri]

Hello,

Im trying to find a macro that would allow me to delete rows A B C D E
when it finds a forward slash. This slash might be mixed in with other
characters.

A B C D E
1 X /RO X X X <--- Forward Slash found Delete
A-E
2 X X X X X
3 X /RO X X X <--- Forward Slash found Delete
A-E
4 X X X X X

Thanks,
Brian

 

[Max]

Try a non-macro way using autofilter?

Do a Data > Filter > Autofilter on col B

Click on the Autofilter drop arrow > choose Custom

Under "Show rows where:"

Select "contains" and type inside the box on the right: */*

Click OK

This filters out all rows with forward slash in col B

Select all the filtered rows

Right-click > Delete Row