How do I test if a cell has any of the special characters e.g. *,?,/. Thanks
How do I test if a cell has any of the special characters e.g. *,?,/. Thanks
Try the following code and it might provide you some help for the process you are looking for.
Code:Function CellHasSpecChar(c As Range) As Boolean CellHasSpecChar = c.Value Like "*[?/*]*" End Function Sub TestIt() MsgBox CellHasSpecChar(ActiveCell) End Sub
Just s right-click and then click on Edit. Then click on Custom and then you go to insert. Then you seeks special characters and finally you made a deposit slip from the menu insertion. Go look at the word or the special characters you are looking for. You can copy / paste or find out that there is any empty value or not.
Bookmarks