Delete row that contains special character *

Thanks a lot. It worked perfect.

Last question, I forgot to ask earlier. What will be new macro if i want to delete both *T or *V? Or let's say delete the row which contains cell starting with special character * (so that it can hanlde both *T and *V). I am ok with either one, whichever is easier to write in macro.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hello canada123,

My 2 cents worth, please if I may?

In the attached WorkBook, on Sheet 1, I am giving you 4 Buttons with Code: The one is to Clear the any "*, $ or &" from Column A regardless of where it may be positioned within any other Text or values. This just Clears it from Column And does not delete any Rows.

The other Button is to Delete the Row where any "*, $ or &" may be in any Row of Column A regardless of where it may be positioned within any other Text or values.

Another Button will delete all Rows regardless of where on the sheet any "*, $ or &", may present itself with of without any other values or Text.

Click on the "Reset" button, to try it as many times as you like.

Then take your pick, and just delete what you don't need.

Hope it solves your issue.

Also see the "Please consider" note at the bottom of this post.

You are welcome!

Hello canada123,


Thank you for the nice Rep.

If you feel that your issue has been resolved, then please do mark your Thread as "Solved".

Happy Coding.

Hi canada123,

Go to the First Post of your Thread, and you will see in the Headings> Thread Tools (I think), but I am sure you'll find it. Select it, and Click on Solved.