ReplaceData
Properties to make search and replace.
Type
Object
Properties
| Name | Type | Description |
|---|---|---|
| LookAt | XlLookAt | Specifies whether the whole search text or any part of the search text is matched. |
| MatchCase | boolean | Case sensitive or not. The default value is "false". |
| ReplaceAll | boolean | Specifies if all the found data will be replaced or not. The default value is "true". |
| Replacement | string | The replacement string. |
| SearchDirection | XlSearchDirection | Range search direction - next match or previous match. |
| SearchOrder | XlSearchOrder | Range search order - by rows or by columns. |
| What | string | undefined | The data to search for. |