¤å¦r¦ê±µ»yªk²¤Æ¤Î©µ¦ù½Ð¯q
- ©«¤l
- 44
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 58
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 8
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-8-15
- ³Ì«áµn¿ý
- 2017-4-18
|
¤å¦r¦ê±µ»yªk²¤Æ¤Î©µ¦ù½Ð¯q
¥H¤U¬O¤p§Ì©å¦Hªº»yªk¡A·Q½Ð°Ý¦p¦ó²¤Æ...¥t¥~·Q½Ð°Ý¤j¤jªº¬OY¤é«á¸ê®Æ¶q¤£¥u¨ì²Ä¥|¦C¡A¦p¦ó³z¹L»yªk¦Û°Ê§PŪ¸ê®Æ¶q¨ì²Ä´X¦C¡A´N°j°é¨ì³Ì«á¤@¦C¡C¬O§_¬OFor...Next »yªk©O?
ÁÂÁ¤j¤jÌ¡C
Sub ¤å¦r¦ê±µ»yªk()
Worksheets("·QnªºtxtÀÉ").Range("a1") = Worksheets("ì©lexcelÀÉ®×").Range("a1") & Worksheets("ì©lexcelÀÉ®×").Range("b1") & Worksheets("ì©lexcelÀÉ®×").Range("f1")
Worksheets("·QnªºtxtÀÉ").Range("a2") = Worksheets("ì©lexcelÀÉ®×").Range("a2") & Worksheets("ì©lexcelÀÉ®×").Range("b2") & Worksheets("ì©lexcelÀÉ®×").Range("f2")
Worksheets("·QnªºtxtÀÉ").Range("a3") = Worksheets("ì©lexcelÀÉ®×").Range("a3") & Worksheets("ì©lexcelÀÉ®×").Range("b3") & Worksheets("ì©lexcelÀÉ®×").Range("f3")
Worksheets("·QnªºtxtÀÉ").Range("a4") = Worksheets("ì©lexcelÀÉ®×").Range("a4") & Worksheets("ì©lexcelÀÉ®×").Range("b4") & Worksheets("ì©lexcelÀÉ®×").Range("f4")
End Sub |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 1# ¾Ç¨ì¦Ñ¦º - Sub EX()
- Dim xA As Worksheet, xB As Worksheet
- Set xA = ThisWorkbook.Worksheets("ì©lEXCELÀÉ®×")
- Set xB = ThisWorkbook.Worksheets("·QnªºTXTÀÉ®×")
- For i = 2 To xA.Cells(4 ^ 8, 1).End(xlUp).Row
- xB.Cells(i, 1) = xA.Cells(i, 1) & xA.Cells(i, 2) & xA.Cells(i, 6)
- Next i
- End Sub
½Æ»s¥N½X |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¦^´_ 1# ¾Ç¨ì¦Ñ¦º
¤U±¦³3Ó¼Ò¦¡¡Aµ¹§A°Ñ¦Ò¡A(¦p¡A§Aªº°ÝÃD¤£¥u¤U±³o3ºØ¼Ò¦¡)- Public Sub Ex()
- Dim ro%, I%
- With Worksheets("ì©lEXCELÀÉ®×")
- ro = .Cells(Rows.Count, 1).End(xlUp).Row '´M§ä³Ì«á¤@¦Cªº¦C¸¹¡A½Ð¬ÝVBE»¡©ú:Range.End ÄÝ©Ê
- For I = 2 To ro '¥H¦C¸¹°µ°j°é
- Worksheets("·QnªºTXTÀÉ®×").Cells(I, "A") = .Cells(I, "A") & .Cells(I, "B") & .Cells(I, "F")
- Next
- End With
- End Sub
- Public Sub test()
- Dim ro%, Rng As Range
- With Worksheets("ì©lEXCELÀÉ®×")
- ro = .Cells(Rows.Count, 1).End(xlUp).Row '´M§ä³Ì«á¤@¦Cªº¦C¸¹¡A½Ð¬ÝVBE»¡©ú:Range.End ÄÝ©Ê
- For Each Rng In .Range("A2:A" & ro) '¥Hª«¥ó¬°°j°é
- Worksheets("·QnªºTXTÀÉ®×").Cells(Rng.Row, "A") = Rng & Rng.Offset(, 1) & Rng.Offset(, 5)
- Next
- End With
- End Sub
- Public Sub test1()
- Dim ro%, Rng As Range
- With Worksheets("ì©lEXCELÀÉ®×")
- ro = 2
- Do Until .Cells(ro, 1) = "" 'A·íÄæ¹J¤WªÅ¥Õ´N¸õÂ÷°j°é
- Worksheets("·QnªºTXTÀÉ®×").Cells(ro, "A") = .Cells(ro, "A") & .Cells(ro, "B") & .Cells(ro, "F")
- ro = ro + 1
- Loop
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 44
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 58
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 8
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-8-15
- ³Ì«áµn¿ý
- 2017-4-18
|
·PÁ¨â¦ì¤j¤j «ü¾É~ |
|
|
|
|
|
|