|
发表于 2012-2-24 13:49
|
显示全部楼层
本楼为最佳答案
- Sub 去掉空格()
- Dim arr
- Dim i As Long, j As Long
- Dim s As String
- arr = Range("A3:O" & [A65536].End(xlUp).Row)
- s = Right(Range("A3"), 1)
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- arr(i, j) = WorksheetFunction.Substitute(arr(i, j), s, "")
- Next j
- Next i
- Range("A3").Resize(UBound(arr), UBound(arr, 2)) = arr
- MsgBox "替换完成"
- End Sub
复制代码 |
|