04 ReplaceAll - AndrewMB2/Logic-Architect-for-Excel-VBA GitHub Wiki
ReplaceAll method
Replaces all occurrences of a value in a given column. Returns True if successful, otherwise False.
Applies to
| TableData | ArrData | RsetData | Xdata | XShared |
|---|---|---|---|---|
| ✓ |
Parameters
| Name | Type | Description |
|---|---|---|
| Field | Variant | Field name or field number. |
| Value1 | Variant | Value to be replaced. |
| Value2 | Variant | Replacement value. |
ReplaceAll replaces all occurrences of the whole value Value1 with Value2 in the field/column identified by Field.