A 10x10 grid?
Maybe what you really want is a two-dimensional array instead. I'm not sure how you intend to read diagonally, but here is how you declare an array:
Code:
Dim Array(10, 10) As String
This declares a two-dimensional array of 11 * 11, a total of 121, with Option Base 0 (the default).
Code:
Dim Array(10, 10, 10) As String
This declares a three-dimensional array of 11 * 11 * 11, a total of 1331, with Option Base 0.
As you can see the three-dimensional array is over 10x bigger, so use only what you need.
NOTE: You can change the type to what suits your application, e.g. variable/fixed length String, or Integer. I wouldn't recommend Variants because of their size.
If you want the array to start at 1, use
lower To
upper.
Code:
Dim Array(1 To 10, 1 To 10, 1 To 10) As String
------------
If you want to store values in an array, you can do this:
To store a string in a three dimensional array (of String type):
Code:
Array(6, 3, 1) = "LabelX"
------------
If you give more specific information it may be easier to understand what you're trying to do, but I hope this helps you.
"For Lucky Best Wash Use Mr Sparkle."