Why doesn't Excel search work if there is a tilde "~" in the value?

Question

Visual Basic

Search in Excel does not work if there is a tilde "~" in the value.
Literally. On the sheet there is something like "Cowberry deputy ~ 10 - 12 kg RUSSIA 730" and if you try to find it through the search with the full name, nothing comes up. It doesn't work as a simple search on the sheet or through the VBA method Range.Find
I need it through VBA. Are there options to fix it?

Answer 1

These are wildcards.
? - any single character;
* – any number of any characters, including zero characters;
~ - put a tilde before ?, * and ~ to stand for themselves
To make a tilde stand for itself in a pattern, you need to write it twice: ~~