What is the meaning of the find function para?

Hi woshichuanqilz,

Excel has formulas as well as VBA. Most of the functions take "parameters" or "arguments", which are the things in the parenthesis after the main word.

Example: VLookup(lookup_value, table_array, column_index_num, [range_lookup])
VLookup is the function which has parms (short for parameters) of
Lookup_Value
Table_Array
Column_Index_num
Range_Lookup (which is an optional argument/parameter)

On the page you are looking at:
https://msdn.microsoft.com/en-us/lib.../ff839746.aspx

The Function is "Find" and it has arguments that are in the parenthesis
The web page explains what each of those arguments is for and if it is need or optional.
It also tells what kind of object the parameter needs to be, like a string or number or range or variant (anything).

I hope that explains how to read the page you found.

There is also a good explanation at:
http://www.cpearson.com/excel/Option...rocedures.aspx

I think in the Find function you search other cells and find what you are looking for using the whole cell or any part of the words in a cell.

Example: Find("Bob",,,xlPart) would find "Bobby" and "Bobber"

Here is another page that gives a better example:

http://ccm.net/faq/31289-search-and-find-using-vba

Thread moved to the VBA section.