Gap between Headings and Start of Output

[Paul Black]

Thanks for the reply Joel,

I think I confused things with my explanation.
If I have the combinations ...

1 2 3 4 5 6 = 21
1 2 3 5 6 7 = 24
1 2 3 6 7 8 = 27
1 2 3 7 8 9 = 30
1 2 3 8 9 10 = 33
1 2 3 9 10 11 = 36
1 2 3 10 11 12 = 39
1 2 3 11 12 16 = 45
1 2 3 12 13 14 = 45

.... for example, the SUM total for 21 would equal 1 occasion.
The SUM total for 45 would equal 2 occasions etc.

Therefore the sum 21 would equal 1 and go in the same row as ...
Cells(RowCount, "B").Value = i
.... where the value 21 is.
It is a count (the same as the existing program) of the number of
times each SUM has occured and will go in column "H" on the same row
as the corresponding number (i). If it has not occured then a zero
will be entered.

Thanks in Advance.
All the Best.
Paul

 

[Paul Black]

Sorry Joel,

There will only be 6 number combinations, so the columns used will
always be "B:G". It is the number of rows that will change. There
could be 3,000 or so rows of draws to evaluate. As you know though the
SUM totals can only be from 21 to 279.

Thanks in Advance.
All the Best.
Paul

 

[Paul Black]

Sorry Joel,

There will only be 6 number combinations, so the columns used will
always be "B:G". It is the number of rows that will change. There
could be 3,000 or so rows of draws to evaluate. As you know though
the
SUM totals can only be from 21 to 279.

Thanks in Advance.
All the Best.
Paul