Hi, I have been racking my brain over this simple problem, but I don't seem to be able to get it right.

I have two incrementing variables.

The variables are:

intRunDiff
intRunCount

what I have is this:

VB Code:
  1. For intRunCount = 1 To 6 

  2.  For intRunDiff = 1 To intWhatever 

  3.   <insert formula here>

  4.  Next intRunDiff 

  5. Next intRunCount

The results should look like this:

Code:
                  intRunDiff    1   2   3   4   5   6   7   8 ...
intRunCount
1                               1   6   5   4   3   2   1   6 ...
2                               2   1   6   5   4   3 ...
3                               3   2   1   6   5   4 ...
4                               4   3   2   1   6   5 ...
5                               5   4   3   2   1   6 ...
6                               6   5   4   3   2   1 ...