|
一个单元格内出现若干个A列的序号,现要将所有序号替换为对应的B列,于是尝试写了如下函数,但是却得不到正确结果,请大神帮我看一下
- Function reval(rng As Range)
- Application.Volatile
- Dim arr, a, s$
- arr = Split(rng.Value, "/")
- For Each a In arr
- s = s & "/" & Columns(1).Find(a, lookat:=xlWhole).Offset(, 1)
- Next
- reval = Mid(s, 2)
- End Function
复制代码
|
|