|
本帖最后由 laoau138 于 2017-10-28 15:37 编辑
VBA自定义函数支持两个区域中的值一一替换
- Function replacetwo(rng1, rng2, rng3)
- Dim arr, brr, i&, s$
- s = rng1: arr = rng2: brr = rng3
- For i = 1 To UBound(arr)
- s = Replace(s, arr(i, 1), brr(i, 1))
- Next i
- replacetwo = s
- End Function
复制代码
|
|