- ©«¤l
- 47
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-1-14
- ³Ì«áµn¿ý
- 2012-3-10
|
¦^´_ 6# Hsieh
½Ð°ÝHsieh «e½ú~
³o¨â¦¸ªºµ{¦¡½X®t§O³Ì¥Dn¬O"x = Application.Max(3, C.Row - 14)"¶Ü?¥Nªí·N«ä¬O?!
¦pªG§Ún§ï§ì°£®§¤é«á30¤éªº³ø¹S¬O¤£¬O±N³¡¤Àµ{¦¡½X§ï±¼§Y¥i?!
If Not C Is Nothing And Not B Is Nothing Then
x = Application.Max(3, C.Row - 14)
Set B1 = .[A1:A2]
Set B2 = B.Resize(2, 1)
Set Rng = .Cells(x, 1).Resize(30, 1)
Set Rng1 = .Cells(x, B.Column).Resize(30, 1)
With sht
B1.Copy .Cells(r, k)
B2.Copy .Cells(r, k + 1)
Rng.Copy .Cells(r + 2, k)
Rng1.Copy .Cells(r + 2, k + 1)
End With
k = IIf(k = 255, 1, k + 2)
r = IIf(k = 1, r + 33, r)
Else
MsgBox "µL¦¹°£Åv¸ê®Æ"
ÁÂÁ±z! |
|