PDA

View Full Version : Sleeper: How could I fill automatically a column using VBA?



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

Jacob Hilderbrand
07-16-2005, 11:09 PM
I looked at the attachment and am not sure what your question is. Can you clarify what you want to do a bit more?