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!
Per Jessen - 23 Nov 2007 19:31 GMT
> Hello,
>
[quoted text clipped - 14 lines]
>
> 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
JLGWhiz - 23 Nov 2007 20:56 GMT
Here is a place to answer some questions:
http://www.excel-vba.com/excel-vba-contents.htm
Just start at the beginning and work your way through. It explains a lot of
the basics and gives examples..
> Hello,
>
[quoted text clipped - 14 lines]
>
> Thanks in advance!