- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 244
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-10
|
- Private Sub CommandButton1_Click()
- Dim ay()
- With Sheets("q³æ")
- r = ActiveCell.Row
- a = .Range(.Cells(r, "B"), .Cells(r, "D")).Value
- b = .Range(.Cells(r, "U"), .Cells(r, "W")).Value
- x = .Cells(r, "S")
- y = .Cells(r, "T")
- For Each c In .Range(.Cells(r, "G"), .Cells(r, "O")).SpecialCells(xlCellTypeConstants, 1)
- k = c.Column
- ar = Array(.Cells(3, k), "", c, Val(.Cells(2, k)), c * 20, Val(.Cells(2, k)) * c * 20)
- ReDim Preserve ay(s)
- ay(s) = ar
- s = s + 1
- Next
- End With
- With Sheets("¥X³f³æ")
- .[B9:G17] = ""
- .[C4].Resize(3, 1) = Application.Transpose(a)
- .[F4].Resize(3, 1) = Application.Transpose(b)
- .[B9].Resize(s, 6) = Application.Transpose(Application.Transpose(ay))
- .[G19] = x
- .[G21] = y
- .Select
- End With
- End Sub
½Æ»s¥N½X ¦^´_ 1# jesscc |
|