Excel VBA Introduction Part 16 - For Next Loops
Why Stack Overflow recommends it
Stack Overflow users link it in comments when a VBA asker needs to loop over cells or ranges and clearly lacks the basics of For Next loops.
Recommended by 3 people across 4 different months, 2016 to 2019.
What it is
A 22-minute tutorial from WiseOwlTutorials, part 16 of an Excel VBA introduction series by Andrew Gould. It shows how to write a For Next loop, control the number of iterations and the direction, and use loops to process collections such as worksheets, workbooks and cells.
What people said
Recommends user6432984 · 2016-10 · Stack Overflow · on “Checking If Two Separate Rows have Duplicates in Multiple Columns Then Performing an Operation (VBA)”
You will greatly benefit from watching this complete series on Youtube: Excel VBA Introduction [LINK] . Excel VBA Introduction Part 16 - For Next Loops [this video] is the relevant one but you really should watch them all.
Recommends user6432984 · 2018-01 · Stack Overflow · on “Executing a loop for a range of cells”
Watch: Excel VBA Introduction Part 16 - For Next Loops [this video] and Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) [LINK]
Recommends TinMan · 2018-12 · Stack Overflow · on “How to write to separate files multiple blocks of rows in same Excel spreadsheet (VBA)?”
This should help you get started: AnalystCave: WRITING FILES IN VBA (TXT, XML, CSV, BINARY) [LINK] , Excel VBA Introduction Part 16 - For Next Loops [this video] , Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) [LINK]
Recommends TinMan · 2018-12 · Stack Overflow · on “Trim characters in months to show just first three characters”
You should watch: Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) [LINK] Excel VBA Introduction Part 16 - For Next Loops [this video] Excel VBA Introduction Part 17 - For Each Loops [LINK]
Recommends Lorne · 2019-08 · Stack Overflow · on “How to make solver to move one cell to the right after ready calculations?”
It appears you have simply recorded an instance of Solver and posted its code here. I have not spent much time trying to understand your specific needs, but I believe you need to use a for loop to iterate over the cells you want to apply your Solver on. Simply put everything inside a for loop and change the target cell, and if necessary the restrictions. If you don't know how a for loop works, here is a tutorial: [this video]
Cites TinMan · 2019-08 · Stack Overflow · on “Referencing a range”
Here are several ways to iterate over the ranges: Using Arrays Private Sub CommandButton1_Click() Dim values As Variant With ThisWorkbook.Worksheets("MasterSheet") values = .Range("A2", .Cells(.Rows.Count, 1)).Resize(, 2).Value End With Dim r As Long Dim newname As String For r = 1 To UBound(values, 2) If values(r, 2) = "Yes" Then newname = values(r, 1) With ThisWorkbook .Sheets.Add(After:=Sheets(.Sheets.Count)).Name = newname End With End If Next ThisWorkbook.Worksheets("MasterSheet").Activate ThisWorkbook.Worksheets("MasterSheet").Cells(1, 1).Select End Sub For Each Loop Private Sub CommandButton1_Click() Dim cell As Range Dim newname As String With ThisWorkbook.Worksheets("MasterSheet") F