Finds and replaces characters in cells on your worksheet
[C++]
static int FormulaReplace(
const char* find_text,
const char* replace_text,
bool look_at_entire_cell,
bool look_by_rows = true,
bool active_cell_only = true,
bool match_case = false
);
Find_text is the text you want to find.
Replace_text is the text you want to replace find_text with.
If true, looks for find_text as the entire contents of a cell. If false, looks for find_text as part of the contents of a cell.
If true, looks for find_text by rows. If false, looks for find_text by columns.
If active_cell_only is true, find_text is replaced in the active cell only. If active_cell is false, find_text is replaced in the entire selection, or, if the selection is a single cell, in the entire sheet.
Match_case is a logical value corresponding to the Match Case check box in the Replace dialog box.
Zero if the function has been called successfully; non-zero
if the function could not be called.
See Error codes for a list
of return values.
See the Microsoft Excel on-line Help for full details about
this function.
Header: xlfuncs.h