- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 4# ã´£³¡ªL
¤F¸Ñ¤F~
¥i§_¸Ñ»¡¤U±ªº¼gªk
For i = 1 To UBound(Arr)
T = Arr(i, 1): R = xD(T)
If R = 0 Then
N = N + 1: R = N: xD(T) = N
Brr(R, 1) = Arr(i, 1): Brr(R, 2) = Arr(i, 2): Brr(R, 3) = Arr(i, 3)
End If
C = Application.Match(Arr(i, 4), Array("°ê»y", "^¤å", "¼Æ¾Ç", "ª«²z", "¤Æ¾Ç"), 0)
Brr(R, C + 3) = Arr(i, 5)
Y¤§«á·Qn¦A¼W¥[¤@Ó¬ì¥Ø
C = Application.Match(Arr(i, 4), Array("°ê»y", "^¤å", "¼Æ¾Ç", "ª«²z", "¤Æ¾Ç","ªÀ·|"), 0)
Brr(R, C + 3) = Arr(i, 6)
¬O¥i¥H³o¼Ë§ï¹À? ·PÁ±zªº±Ð¾Ç |
|