For example, to match to a question mark, use.
The sort order is based on the code page currently being used, as determined by the Windows regional settings.Text comparison, the alternative to binary comparison, is case insensitive therefore, A = a.Binary comparison is based on comparing the internal binary number representing each character this produces a case-sensitive comparison.This can be overridden using the Option Compare statement. The default comparison method for the Like operator is binary.
If either string or pattern is Null, then result is Null.
Please leave your comments or queries under comment section also please do subscribe to our blogs to keep your self upto date.If string matches pattern, result is True otherwise, result is False.Ī series of characters used by the Like operator to determine if string and pattern match.ĭetermines if a string matches a given pattern. OCell.BorderAround LineStyle:=XlLineStyle.xlDash, Weight:=xlThick, ColorIndex:=xlColorIndexAutomatic, Color:=vbRed
'apply border around each cell in selection