Summary of Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)
In this YouTube video, an introduction to Excel VBA is provided, focusing on selecting cells using various methods such as Range, Cells, ActiveCell, End, and Offset. The video covers selecting cells based on their absolute position on the worksheet, selecting a cell using the ActiveCell keyword, and selecting multiple cells. It also discusses selecting cells relatively by finding the end of a list, moving up, down, left, or right on the worksheet, and selecting entire regions or columns. The methodology includes inserting a new module, renaming modules, selecting individual cells, changing cell values without selecting them, creating range names, and referring to cells relatively.
### Methodology
1. Insert a new module in the VBA editor.
2. Use keywords like Range and Cells to refer to cells based on their absolute position.
3. Use the ActiveCell keyword to refer to the currently selected cell.
4. Select multiple cells using the Range keyword and the Selection keyword.
5. Change cell values without selecting them by directly referring to the cell properties.
6. Refer to cells relatively by finding the end of a list and moving up, down, left, or right.
7. Create range names in Excel by selecting cells and using the "create from selection" feature.
8. Refer to range names in VBA by using the range name followed by properties.
9. Move down to the end of a list in a downward direction by using the End property with the direction "Excel down."
10. Use the Offset property to move to a cell below the current active cell.
### Speakers
- Not specified in the subtitles.
Notable Quotes
—
11:26
— « a known fixed starting point from there","a known fixed starting point from there"],
[" »
—
11:28
— « we'll simulate getting down to the end","we'll simulate getting down to the end"],
[" »
—
12:27
— « so you can see it a little bit more clearly","so you can see it a little bit more clearly"],
[" »
—
19:26
— « we'll write a simple routine that will add new films to the list","we'll write a simple routine that will add new films to the list"],
[" »
—
23:23
— « selects preferr to our range of film ID","selects preferr to our range of film ID"] »