|
发表于 2014-3-19 17:16
|
显示全部楼层
本楼为最佳答案
附件请测试- Private Sub CommandButton1_Click()
- Dim arr, i&
- arr = [a1].CurrentRegion
- For i = 2 To UBound(arr)
- If arr(i, 1) = "" Then arr(i, 1) = arr(i - 1, 1)
- Next i
- [a1].Resize(UBound(arr)) = Application.Index(arr, , 1)
- End Sub
复制代码 |
|