View original (French)

Increment a column

Solved
mylord6666 Posted messages 62 Status Member -  
mylord6666 Posted messages 62 Status Member -
Hello,

I'm struggling with a command and I hope you can enlighten me.
Thank you in advance.

How to store in a table knowing the line number and increment the column each time we want to store a value?
Is there an if with exit condition?

Configuration: Windows Vista / Firefox 29.0

2 answers

  1.
    f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
     
    Hello,
    example: 
    Sub test()
     With Worksheets("Sheet1")
     line = 2
     For x = 1 To 10
     .Cells(line, x) = x
     Next x
     End With
    End Sub
    0
  2. mylord6666 Posted messages 62 Status Member
     
    Thank you very much.
    0