21May2015

INSTRING function in VBA

Instring function in VBA returns the position of the first occurrence of a substring. This function can be used to find whether the search string (Sub string) is present in a string. Syntax:  InStr( [start], string, substring, [compare] ) Start: It is the starting position for the search. If this parameter is omitted, then default