Hi All,

I am trying to create an array with certain column values of a row (as they contain some dates which I have to compare), for e.g. in my excel sheet I want "N,O,P,Q,R,S,T,V,X,Y,Z" columns value of row '3' in an array. I have several thousand of rows in the excel, so I would have to do same thing on each row. I have tried something like this, using a while loop I am iterating through each row and to track the row number I maintain a counter let suppose 'i' and capturing above columns as:
Range("Ni,Oi,Pi,Qi,Ri,Si,Ti,Vi,Xi,Yi,Zi").Select, but this statement is giving error as value of variable 'i' is not getting substituted.

Is it possible to substitute the value of 'i' inside Range() function? If not then how can I get these columns value in an array?


Thanks in advance
Amit