Looping through columns

[kosherboy]

Hello,
I thought that looping through columns would be the same as looping through rows, but this is not so
From my limited knowledge in VBA, "Long" refers to rows and "Integer" refers to columns, please correct me if i am wrong.
Here is what i have so far:

Please Login or Register  to view this content.

[1aaaaaaaaaaaaaaa]

instead of range, use cells object reference, Cells(Row Index, Column Index)

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[kosherboy]

Thanks Poizhan and John.
Both answers are right on!
Thanks!
Question: Why can't i use the "Range" tool instead of having to use the "Cell" tool?

[1aaaaaaaaaaaaaaa]

Range wants to reference a cell or grouping of cells by Column/Row in [A-Z][0-9] format, since you are using a numeric value to iterate through columns instead of an alphabetic value, the range reference will fail, e.g. "Range A1": (ColCel & NR), vba sees this as Range(11) which is invalid reference.

[kosherboy]

Range wants to reference a cell or grouping of cells by Column/Row in [A-Z][0-9] format, since you are using a numeric value to iterate through columns instead of an alphabetic value, the range reference will fail, e.g. "Range A1": (ColCel & NR), vba sees this as Range(11) which is invalid reference.

Ah! That makes sense!
Thanks!