Im trying to put it in by specifying a using the macro to specify a
table on a work sheet, making in active and then the command
selection.Array. (I think that is the commands)
I have got the program to work using the 'offset' command and using the
content of the activated cell as a check reference BUT I have to loop
this 126 times. My thinking is that if I pop this table (which can
change into an array the macro should be a bit faster)
Would it help if I posted the routine?

Gary

In article ,
says...
How is the data put into the array?

Alan Beban

Gary wrote:

I am having problems with arrays, I want to use a table (on a worksheet)
as an indexing/sorting system using a couple of loops (21 rows of 6)
columns. I have tried to workout how to do this from the help files but
to no avail. Could someone please help with the basics I.e. declaring
and naming the array and then the proper wording for retrieving the
information from within the array (if you know what I mean)It will be
text stored in the array
I thought it was something like
dim myarray (21, 6) 'defining the size
myarray (1,1) 'to get the information in column 1 row 1 from the array
But this doesn't work
\0\0\0\0\0