loop through columns (using for-loop)

K

Kurt

Hello,

I now discovered the syntax to loop through rows:
example:

For i = 3 To 20
If Range("A" & i).Value = "" Then
Range("A" & 1).Copy Destination:=Range("A" & i)
End If
Next i

How can I use the same method for scrolling trough columns?
How can I get to column B using something like "A+1"

extra question: why is the "Next i" placed behind the for-loop? Isn't
it placed in the for-loop with other languages?

Thanks in advance!
 
P

Per Jessen

Hello,

I now discovered the syntax to loop through rows:
example:

For i = 3 To 20
If Range("A" & i).Value = "" Then
Range("A" & 1).Copy Destination:=Range("A" & i)
End If
Next i

How can I use the same method for scrolling trough columns?
How can I get to column B using something like "A+1"

extra question: why is the "Next i" placed behind the for-loop? Isn't
it placed in the for-loop with other languages?

Thanks in advance!

Hi Kurt

MyRow = 1
For i = 3 To 20
If Cells(MyRow, i).Value = "" Then Cells(MyRow, i) = Cells(MyRow,
1).Value
Next

Regards,

Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top