- ©«¤l
- 5
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 52
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2015-11-14
- ³Ì«áµn¿ý
- 2022-11-30
|
·PÁ¼ӤW~§Úè¦n¦³»Pµo¤åªÌÃþ¦ü»Ý¨D
©Ò¥H´N¥Î¦P¼Ë¼gªk¦A§ó§ï¡A¥u¬OÄæ¦ì»Ý¨DÅܤj
Sub fourFATNOcombine()
' fourFATNOcombine ¥¨¶°
'
Dim Out As Variant
For n = 3 To 2000
If Cells(n, 2) <> "" Then
Out = Array(Cells(n, 146), Cells(n, 245))
***¤W±³o¤@¬q§Ún±q146Äæ¦Y¸ê®Æ¨ì245Äæ¡A¤gªk·Ò¿û¦ü¥GµLªk¸Ñ
ub = UBound(Out)
For i = 0 To ub
If Out(i) <> "" Then: OutAll = OutAll & "/" &
Out(i)
Next
Cells(n, 9) = Mid(OutAll, 2, 999)
OutAll = ""
End If
Next |
|