By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (17 of 1182)

(Clear Filter = *loop*)

For loop - lbound ubound
exit for ' prematurely exit from a for loop
nested for loops
Do While - Loop
Goto Loop
Exiting loops
For each (loop) item in collection
When deleting work backwards: for x = sheets.count to 1 step -1 (loop)
for k = 1 to 12 step 3 ' loop
Do - Loop ' no while needs Exit Do
Insert_to_dataissues_click - Loop thru data on sheet and insert it to a table
Exit Do
Loop
While Not EOF(1) ... Wend - loop
Optimize - getlistcount(nnnnn) in a loop with 800 items
What you can record and what you can't (loops, decisions, flexibility)
For Loop with Birthday Problem