What is the code line to move from one column to the next column in Excel using code?
March 13th, 2010 | 
Author: I need to write two loops in Excel,
1)to go down the rows [This I can do because the rows are numbered]
2)to go across the columns [This I don’t know how to do because column are in Alphabetics]
The code should go down a set of continuous rows in a column, then move over to the next column and move down the rows again. I have many columns.
Posted in 
Tags:
Assume you know where to put this code http://www.freewebs.com/swhtam/YA/selectEachCell.txt and the goal of your code is to select each cell in the range top down each row in same column then repeat left to right across each column.
In the code, there is 3 lines that cause time lags in execution of code, so the selection of cell can be seen, remove them if normal run is expected.
Please contact for more details.
You need a macro for this. If you don’t know anything about Excel macros, then you should read up on it, because it’s a bit complicated. They are written in Visual Basic, which is not that hard, but it takes a little getting used to if you are not familiar with programming.
It can’t be done with cell references.