Sub kaisubetu_box_pea() 'ボックスペアを回数毎に計算するbox_pea_kai()で出したデータを元に Dim Lastgyou As Long, owari As Long, kai As Variant Dim i As Long, ii As Long Sheets("ストレートパターン").Select
Sub box_pea_kai() 'ナンバーズ4ボックスペア1回ずつ出す Dim i As Long, Lastgyou As Long, kai As Long, bx_no As Range Dim j As Long, k As Long, reiti As Long, l As Long, m As Long i = 10
Lastgyou = Cells(Rows.Count, 3).End(xlUp).Row kai = 3 Range("wy4:zi7000").ClearContents
For j = 4 To Lastgyou For k = 1 To 6 ’6個のボックスペアの位置に集計 出力結果表 Set bx_no = Cells(j, k + 623) reiti = Range("xg3:zi3").Find(bx_no).Column Cells(j, reiti) = Cells(j, reiti) + 1 Next k
Next j
For l = 0 To 54 'ボックスペア累計出現数 Cells(2, l + 631) = Application.Sum(Range(Cells(4, l + 631), Cells(Lastgyou, l + 631))) Next l