|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Private Sub CommandButton39_Click()
- Range("A4:F23").ClearContents
- [d24] = ""
- [a25] = ""
- [b25] = ""
- [d25] = ""
- End Sub
- Sub 编号()
- ar = Range("A4:F23")
- For j = 1 To UBound(ar, 2) Step 3
- For i = 1 To UBound(ar)
- If Len(ar(i, j + 1) & ar(i, j + 2)) Then
- n = n + 1
- ar(i, j) = n
- End If
- Next i
- Next j
- [a4].Resize(UBound(ar), 1) = Application.WorksheetFunction.Index(ar, 0, 1)
- [d4].Resize(UBound(ar), 1) = Application.WorksheetFunction.Index(ar, 0, 4)
- End Sub
复制代码 |
|