Programming Reference Manual

BulkReplace

 
Syntax
 
Value = BulkReplace(Source, Var1...Varn)
 
Description
A replacement for nested Replace$ functions with the same replacement values
Note: the latest parameter is the replacement value
 
Parameter
Description
Source
The string upon the replacements will take place.
Var1...Varn
ParamArray. A range of values that all need to be replaced by the latest parameter in this range.
Value
String. The result of the replacements.
See Also
Replace, ReplaceString.
Example
 
Sub Main
    Debug.Print BulkReplace("This house has an elevator.", "this," "an", "---") 
End Sub