Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What kind of loop do I need for filling A6 till A60 and then go to D6 and
filling till D60. My code is: Sub Nummeren() Dim lStart As Long Dim lStop As Long Dim i As Integer Dim lTeller As Long lStart = Range("J1").Value lStop = Range("K1").Value i = 6 For lTeller = lStart To lStop Step 10 Cells(i, 2).Value = lTeller i = i + 1 Next End Sub With this code I want to fill the column B6 till B60, then jump to D6 till D60. etc. The teller stops when it is reaching the number mentioned in lstop. J1 = 38400 K1 = 38800 Who can help? John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filling in blank cells with information from cells above it | Excel Discussion (Misc queries) | |||
Filling cells | Excel Discussion (Misc queries) | |||
filling cells | Excel Discussion (Misc queries) | |||
filling cells | Excel Discussion (Misc queries) | |||
filling cells | Excel Discussion (Misc queries) |