Hi, I've seen a couple of threads relating to creating a spiral where the starting point is from the middle - one elegant solution I saw was using the offset range property method.
My question is a variation on this theme. Given a number of rows and columns (say r = 4 and c = 5) how can the following output be achieved:
1 2 3 4 5 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
14 15 16 17 6<o></o>
13 20 19 18 7<o></o>
12 11 10 9 8<o></o>
So the 'Spiral' is working itself from the outside perimeter into the centre.
Any suggestions would be most helpful!
My question is a variation on this theme. Given a number of rows and columns (say r = 4 and c = 5) how can the following output be achieved:
1 2 3 4 5 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
14 15 16 17 6<o></o>
13 20 19 18 7<o></o>
12 11 10 9 8<o></o>
So the 'Spiral' is working itself from the outside perimeter into the centre.
Any suggestions would be most helpful!