Write a for loop from left to right

**ccs_1981** · 09-09-2011, 04:26 AM

Dear all,

how to write a for loop to increase the cell from left to right as below:

how to increase the range from Cells("1", "C") -> Cells("1", "D") ->Cells("1", "E") -> Cells("1", "F") from ABC...

Please Login or Register  to view this content.

**Andrew-R** · 09-09-2011, 04:44 AM

Hi, your code neeeds to be enclosed in code tags or you'll get your knuckles rapped.

As for your questions - you do realise that you can use numeric values for the column as well as the row, don't you? So Cells(1,3) is the same as Cells(1,"C") and Cells(1,4) is the same as Cells(1,"D") as so on. If you're looping it's much easier to use column numbers rather than try to reference the alphabetic address of the cell.

**snb** · 09-09-2011, 05:17 AM

What is the result you want ? numeric or text ?

1 2 3 4 5 6

or

A B C D E F

because you can do this using autofill; no VBA required.

**ccs_1981** · 09-09-2011, 05:20 AM

Originally Posted by Andrew-R

Hi, your code neeeds to be enclosed in code tags or you'll get your knuckles rapped.

As for your questions - you do realise that you can use numeric values for the column as well as the row, don't you? So Cells(1,3) is the same as Cells(1,"C") and Cells(1,4) is the same as Cells(1,"D") as so on. If you're looping it's much easier to use column numbers rather than try to reference the alphabetic address of the cell.

thanks, it solved.