Excel VBA Tutorial for Beginners (Part 4/10): The Range Object

Welcome to the Excel Macros/VBA tutorial for beginners. In this fourth video we'll work with the Range object. We will learn how to reference a range, useful properties of a range such as Cells, Offset, CurrentRegion, Value, and more, how to set the color of the Font, Interior, and Borders of a range, and how to select, copy/paste, clear or delete a range or cell (see timeline below).

00:00 Intro
00:18 How to reference a range
03:53 Cells and Offset properties
05:30 CurrentRegion, Address, Count, and Value properties
08:26 Font, Interior, and Borders properties
09:34 How to set the color in VBA
12:04 Select/Activate, Copy/Paste, Clear, Delete methods

In the next video we will learn to use variables in Excel VBA. Upcoming videos will cover the contents as per below.

Contents:
1. Introduction
2. Modules and Procedures
3. Excel Object Model
4. The Range Object
5. Variables
6. Conditions and Loops
7. Arrays
8. Messages and Input
9. Userforms
10. Debugging and Error Handling

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:

[Flugfritze]

Fkn youtube algorithm. This video "cannot" be found by search, it's the 10th result or so. But his playlist is pure gold. Thank you so much!

[khalidmajeed]

providing us a knowledge to go a head.Jazakallah

[altafmehrab]

Sorry to say that this channel is so hidden