Sub kugiritest() Dim mae Dim ato Dim saki Dim gyo Dim moji Dim n
saki = 2
For gyo = 2 To 7 mae = 0 ato = 0 moji = Range("D" & gyo).Value For n = 1 To Len(moji) If Mid(moji, n, 1) = "、" Then mae = ato ato = n Range("G" & saki).Value = Range("B" & gyo).Value Range("L" & saki).Value = Mid(moji, mae + 1, ato - mae - 1) saki = saki + 1 End If Next mae = ato Range("G" & saki).Value = Range("B" & gyo).Value Range("L" & saki).Value = Mid(moji, mae + 1) saki = saki + 1 Next End Sub
受講生さんの投稿
(投稿ID: 3048)
何度も申し訳ございません。
構文の上が切れてしまいました。
貼り直しさせていただきます・・・
Sub kugiritest()
Dim mae
Dim ato
Dim saki
Dim gyo
Dim moji
Dim n
saki = 2
For gyo = 2 To 7
mae = 0
ato = 0
moji = Range("D" & gyo).Value
For n = 1 To Len(moji)
If Mid(moji, n, 1) = "、" Then
mae = ato
ato = n
Range("G" & saki).Value = Range("B" & gyo).Value
Range("L" & saki).Value = Mid(moji, mae + 1, ato - mae - 1)
saki = saki + 1
End If
Next
mae = ato
Range("G" & saki).Value = Range("B" & gyo).Value
Range("L" & saki).Value = Mid(moji, mae + 1)
saki = saki + 1
Next
End Sub