¤@¡B½Ð°Ý«ç»ò²¤Æ
¤G¡B¬°¦ó³£¥u¦³¿ý¤JCells(51, n)?
Y = Sheets("¦¨¥æ«È¤á").Range("b65536").End(xlUp).Row
With Sheets("¦¨¥æ«È¤á")
.Range("a" & Y + 1) = Sheets("¤é³øªí¿é¤J").Range("e2").Value '¤é´Á
For n = 3 To 7
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(41, n).Value
If Sheets("¤é³øªí¿é¤J").Cells(42, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(42, n).Value
End If
If Sheets("¤é³øªí¿é¤J").Cells(43, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(43, n).Value
End If
Next n
If Sheets("¤é³øªí¿é¤J").Cells(44, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(44, n).Value
End If
If Sheets("¤é³øªí¿é¤J").Cells(45, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(45, n).Value
End If
If Sheets("¤é³øªí¿é¤J").Cells(46, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(46, n).Value
End If
Next n
If Sheets("¤é³øªí¿é¤J").Cells(47, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(47, n).Value
End If
If Sheets("¤é³øªí¿é¤J").Cells(48, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(48, n).Value
End If
If Sheets("¤é³øªí¿é¤J").Cells(49, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(49, n).Value
End If
Next n
If Sheets("¤é³øªí¿é¤J").Cells(50, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(50, n).Value
End If
If Sheets("¤é³øªí¿é¤J").Cells(51, n).Value <> "" Then
.Cells(Y + 1, n - 1) = Sheets("¤é³øªí¿é¤J").Cells(51, n).Value
End If
Next n |