Excel VBA Introduction Part 15a - Find and FindNext
Why Stack Overflow recommends it
Stack Overflow users link it, usually alongside the Selecting Cells video in the same series, when asker code misuses Range.Find or loops incorrectly.
Recommended by 3 people across 3 different months, 2016 to 2018.
What it is
A tutorial from Wise Owl's Excel VBA Introduction series, presented by Andrew Gould, on using the Find and FindNext methods to locate values in a worksheet. It covers case-sensitive searches, full versus partial matches, and Do While loops to find every instance of a search term.
What people said
Recommends user6432984 · 2016-10 · Stack Overflow · on “loop function keeps running VBA Excel”
You need to watch Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) [LINK] and Excel VBA Introduction Part 15a - Find and FindNext [this video]
Recommends user9298223 · 2018-05 · Stack Overflow · on “Populating a listbox in a userform by finding a specific word within the excel spreadsheet”
You should watch these videos before preceding: Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) [LINK] , Excel VBA Introduction Part 15a - Find and FindNext [this video]
Recommends TinMan · 2018-12 · Stack Overflow · on “VBA Named Range in Excel Formula”
All the ranges should be fully qualified to the same worksheet Combined_Data . You also need to set the Range.Find() After parameter to the first cell in the Range. Dim marker As Range With Combined_Data Set marker = .Range("A1:AZ200").Find("Marker", After:=.Range("A1")) If Not marker Is Nothing Then Set marker = marker.Offset(1, 0) Set marker = .Range(marker, marker.End(xlDown)) marker.Name = "Marker" End If End With These videos will help: Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) [LINK] and Excel VBA Introduction Part 15a - Find and FindNext [this video]