looking across an array

[Ted Hepworth]

I have a block of data, x rows, y columns. I am trying to read across them one at a time using a macro. I can read across easily using a Do While/Loop routine but cannot get it to step down the rows. I have been trying to use an inner and an outer loop routines without success.
My ultimate goal is to do a Select Case function in each cell to build up a list of integer variable values when the whole array has been analysed.

 

[Juan Pablo González]

<pre>For i = 1 to y
for j = 1 to x
With Cells(i,j)
'Something here
End With
Next j
Next i</pre>

if this isn't what you want, what have you tried ?

 

[Juan Pablo González]

Ted, please keep all replies in the board. You need the COUNTIF function to accomplish what you want.