Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you loop NON-SEQUENTIALLY?
Try this: Private Sub CommandButton1_Click() myArr = Array(1, 3, 11, 12, 30, 40, 99) For i = 1 To 7 For j = 0 To UBound(myArr) - 1 Cells(myArr(j), "a") = "testing" Next Next End Sub Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=378912 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill down sequentially | Excel Worksheet Functions | |||
sorting sequentially | Excel Discussion (Misc queries) | |||
Adding data sequentially | Excel Discussion (Misc queries) | |||
NAME SHEETS sequentially | Excel Discussion (Misc queries) | |||
Run Macros Sequentially | Excel Programming |