VBA using for-next loop to produce following output

[pinkalpaca]

A b c d e
1 1 2 3
2 4 5 6
3 7 8 9
4 10 11 12
5 13 14 15


a b c d
1 4
2 2
3 1 5
4 3
5 6

a b c d
1 1
2 2 3
3 4
4

a b c d
1 3 4
2 1 2
3
4

[daffodil11]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[daffodil11]

Please Login or Register  to view this content.

[tigeravatar]

@daffodil,

Unfortunately, pinkalpaca's post did not come out formatted correctly, and as a result your provided codes don't yield the desired results. Here are pinkalpaca's sequences formatted correctly:

Please Login or Register  to view this content.

@pinkalpaca,

Why do you need this? I don't see any reason you would need a macro for this because you would just create the pattern you want by hand, especially since the numbering seems to be somewhat random and dependent on the sequence you want.