Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a macro that will prompt me with boxes and create a list of numbers but I am looking for a way to get the macro to put the values into every other cell. Any help would be great! Heres what I have so far: Range("A2").Select Range(Selection, Selection.End(xlDown)).Select Selection.ClearContents a = InputBox("How many samples?", "How many samples") b = InputBox("Split where?", "Split after what number?") a1 = 1 b1 = b For i = 1 To b Worksheets("button to make list").Range("A2").Offset(i - 1, 0).Value = a1 a1 = a1 + 1 Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert line every x lines until end of data | Excel Programming | |||
macro to insert blank line when lines sum to zero | Excel Discussion (Misc queries) | |||
How do I copy cells and skip lines? | Excel Discussion (Misc queries) | |||
how do you skip lines when reading a text file | Excel Programming | |||
Excel skip some lines of VBA code | Excel Programming |