Apart from the first parameter, everything is optional. This is the explanation of the syntax of the VBA FIND method. If you are searching for format then you need to use Application.FindFormat method. SearchFormat: Are you searching by formatting. MatchByte: This is only for double-byte languages. MatchCase: The content you are searching for is case sensitive or not.
SearchDirection: Are you looking at the next cell or previous cell. SearchOrder: Are you looking in rows or Columns. LookAt: Whether you are searching for the whole content or only the part of the content. Parameters are xlFormulas, xlValues, xlComments. LookIn: Where to look for the thing you are searching For example Formulas, Values, or Comments. After: After which cell you want to search for.
0 kommentar(er)
