Hi All,
I am new to this and trying to understand loops and arrays
I have my first loop that adds 1 to 10 on column A1 and works.....
I can move the colum with second 1 to say C1 etc but I don't know how to move the start to say A12?
Also I want to add text say "test" so the loop would add 1 test, 2 test etc, can this be done? I knoiw this is a simple loop but I need to get my head around the programming.
![]()
Sub first() For i = 1 To 10 Cells(i, 1) = i Next i End Sub
Bookmarks