|
本帖最后由 yanchuenlei 于 2021-4-2 14:41 编辑
- Sub mo()
- Dim br
- Dim n%
- If n = 0 Then Exit Sub
- If Sheet1.OptionButton1 Then
- Set sjsht = Sheet5
- ElseIf Sheet1.OptionButton2 Then
- Set sjsht = Sheet3
- ElseIf Sheet1.OptionButton3 Then
- Set sjsht = Sheet2
- End If
-
- For i = 1 To n
- For j = 1 To 25
- br(i, j) = Sheet1.Cells(i + 4, j)
- sjsht.Cells(br(i, 25), j) = br(i, j)
- Next
- Next
- Sheet1.Range("a5").Resize(n, 25).ClearContents
- n = 0
- Erase br
- End Sub
复制代码 这个代码改的不对 请大神修正一下
|
|