- ©«¤l
- 150
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 215
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- sp3
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2013-7-15
- ³Ì«áµn¿ý
- 2024-10-2
|
µ{¦¡½s¼g§¹«á,³]©w«ö¶s,«ü©w¥¨¶°,«ü©w¥¨¶°®É,
·|¥X²{ "°Ñ·Ó¨Ó·½¥²¶·¬O¥¨¶°ªí" ªº¿ù»~°T®§
¤£ª¾¬O³]©w¤W¦³°ÝÃD ? ÁÙ¬Oµ{¦¡½X¦³°ÝÃD ?
½Ð±Ð°ª¤â¤j¤jn¦p¦ó¸Ñ¨M! ÁÂÁ·P®¦
µ{¦¡½X¦p¤U
Dim x
Sub b1()
'
' b1 b
'¨C¤ë¸ê®Æ¾ã²zµ{§Ç
x = InputBox("¦~¤ë") 'Äæ¦ì¦WºÙ
If Mid(x, 4, 1) = 1 Then
x1 = Mid(x, 4, 2)
Else
x1 = Mid(x, 5, 1)
End If
x2 = x1
x1 = x1 & "¤ë"
x2 = x2 & "¤ë±Æ¦W"
Call b11
Sheets(x1).Select
Call b12
Sheets(x2).Select
Call b12
MsgBox "·s¼W§¹¦¨"
End Sub
Sub b11()
'yoy¤ÀªR¸ê®Æ¾ã²z
Application.ScreenUpdating = False '°±¤î¿Ã¹õ§ó·s¥H¥[§Ö³t«×
Sheets("yoy¤ÀªR").Select
'x = InputBox("¦~¤ë") 'ºÄæ¦WºÙ
y = Cells(1, 1).End(xlToRight).Column '§ä³Ì«á¤@Äæ¸ê®Æ
Z = Cells(1, y).End(xlDown).Row '§ä³Ì«á¤@¦C¸ê®Æ
Cells(1, y + 1) = x
Range(Cells(2, y), Cells(Z, y)).Copy Range(Cells(2, y + 1), Cells(Z, y + 1))
Range(Cells(2, y), Cells(Z, y)).Copy
Cells(2, y).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False '¿ï¾Ü©Ê¶K¤WÈ
End Sub
Sub b12()
'¤ë±Æ¦W¸ê®Æ¾ã²z
'x = InputBox("¦~¤ë") 'ºÄæ¦WºÙ
y = Cells(1, 1).End(xlToRight).Column '§ä³Ì«á¤@Äæ¸ê®Æ
Z = Cells(1, y).End(xlDown).Row '§ä³Ì«á¤@¦C¸ê®Æ
Cells(1, y + 1) = x
Range(Cells(2, y), Cells(Z, y)).Copy Range(Cells(2, y + 1), Cells(Z, y + 1))
Range(Cells(2, y), Cells(Z, y)).Copy
Cells(2, y).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False '¿ï¾Ü©Ê¶K¤WÈ
End Sub |
|