frade
06-22-2005, 03:15 AM
Hello,
How could I fill automatically a column (Sheet 'Repeatability' column D
called ref_Sample) using VBA?
Please have a look at my file
With this code.. it's possible to create a sheet which contains
ascending values by the way. But, in the case where you have an
array or something like that (e.g. sheet 'intro' column E)
I would like to modify my code to display the values
For i = 1 To Days
For k = 1 To test
For J = 1 To Repetitions
Sheets(2).Range("c2").Offset(l, 0) = k
Sheets(2).Range("c2").Offset(l, -1) = i
Sheets(2).Range("c2").Offset(l, -2) = l + 1
Sheets(2).Range("c2").Offset(l, 2) = J
l = l + 1
Next J
Next k
Next i
Thanks a lot from your help
Best regards,
Fran?ois, from Brussels
How could I fill automatically a column (Sheet 'Repeatability' column D
called ref_Sample) using VBA?
Please have a look at my file
With this code.. it's possible to create a sheet which contains
ascending values by the way. But, in the case where you have an
array or something like that (e.g. sheet 'intro' column E)
I would like to modify my code to display the values
For i = 1 To Days
For k = 1 To test
For J = 1 To Repetitions
Sheets(2).Range("c2").Offset(l, 0) = k
Sheets(2).Range("c2").Offset(l, -1) = i
Sheets(2).Range("c2").Offset(l, -2) = l + 1
Sheets(2).Range("c2").Offset(l, 2) = J
l = l + 1
Next J
Next k
Next i
Thanks a lot from your help
Best regards,
Fran?ois, from Brussels