- ©«¤l
- 25
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 51
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 11 ±M·~ª©
- ³nÅ骩¥»
- OFFICE 365
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2023-2-14
- ³Ì«áµn¿ý
- 2023-12-26
|
Public wst As String
Public j As Integer
Sub test()
Dim i As Integer
For i = 4 To 9999
If (Sheets("¥Dªí®æ").Range("A" & i) = "" And Sheets("¥Dªí®æ").Range("B" & i) = "") Then
Sheets("¥Dªí®æ").Range("B" & i) = Sheets(wst).Range("B" & j)
Sheets("¥Dªí®æ").Range("C" & i) = Sheets(wst).Range("C" & j)
Sheets("¥Dªí®æ").Range("E" & i) = Sheets(wst).Range("D" & j)
Sheets("¥Dªí®æ").Range("F" & i) = Sheets(wst).Range("E" & j)
Sheets("¥Dªí®æ").Range("G" & i) = Sheets(wst).Range("F" & j)
Exit For
Else
End If
Next i
Sheets("¥Dªí®æ").Activate
End Sub
------------------------------------------------------------------------
Private Sub CommandButton1_Click()
wst = "°Ñ¦Òªí1"
j = ActiveCell.Row
Application.Run "Module1.test"
End Sub
-------------------------------------------------------
«e½ú¤j¤j¡A³o¬O«ö¶s¤ºªºµ{¦¡½X¡A¥Ø«eªº¤è¦¡¬O³Q¿ï¨ú¨ìªº¨º¤@¦æ´N·|¦Û°Ê¥[¤J¨ì¥Dªí®æ
¦ý·Qn§ó§ï¬°¥i¥H§å¦¸¥[¤J¡A¤£ª¾¦³¨S¦³¦n¤èªk¡AÁÂÁ |
|