Hi there
I'm currently working on a loop to move from one column to another. Example:
For a = 1 To UBound(file)
Cells(2, 3 + a - 1).Select
Next a
(This is incomplete, I know this loop makes no sense.
)
I'm well aware that this is just moving from one cell to another from left to right.
What I'm trying to achieve is something like, Cells(2, 3 + a - 1 : 100, 3 + a - 1), but i know this is incorrect and invalid. Btw, I used 3 + a - 1 because my work starts from the 3rd column, putting it this way makes it easier for myself and others to see what am I trying to do with the columns.
I know this would be easy if I'm working it in rows, since i can put it like Range("A" & 2 + a), but in this case, changing columns, i can't add the 'a' to the 'A', since A + 1 doesn't equal to B in this case. Any ideas? Any help would be very much appreciated.
Thanks for your time,
CJ
I'm currently working on a loop to move from one column to another. Example:
For a = 1 To UBound(file)
Cells(2, 3 + a - 1).Select
Next a
(This is incomplete, I know this loop makes no sense.
)I'm well aware that this is just moving from one cell to another from left to right.
What I'm trying to achieve is something like, Cells(2, 3 + a - 1 : 100, 3 + a - 1), but i know this is incorrect and invalid. Btw, I used 3 + a - 1 because my work starts from the 3rd column, putting it this way makes it easier for myself and others to see what am I trying to do with the columns.
I know this would be easy if I'm working it in rows, since i can put it like Range("A" & 2 + a), but in this case, changing columns, i can't add the 'a' to the 'A', since A + 1 doesn't equal to B in this case. Any ideas? Any help would be very much appreciated.
Thanks for your time,
CJ
