01 Excel VBA 101: Read and Write Cell Data with Range & Cells Objects

The Range Object

Intro and Course Files Download Sample Lesson

Get The Developer Ribbon (PC and Mac) Sample Lesson

What Is The Range Object and Your First Macro From Scratch Sample Lesson

Adding Secondary or Subsequent Commands Sample Lesson

Debugging in Excel VBA and Stepping Through Code

Three Easy Ways To Test Or Store A Value

How and When To Record a Macro (Plus Clean Up Tips)

Three Main Data Type Notations For Entering Into Cells

Several Ways of Triggering Macros (Intro To Buttons and Fun Controls)

Exercise 01 - Objectives Overview

Exercise 01 - Solution

Affecting Multiple Cells With One Range Command

Using A Named Range With The Range Object

Tips and Best Practices For Better Development Skills

Range Object Quiz

01 - Range Object Quiz

Range Properties

VALUE, TEXT and FORMULA Properties - Reading and Writing Functions To a Cell

Row and Column Properties

Exercise 02a - Objectives Overview

Exercise 02a - Solution

ADDRESS Property

NUMBERFORMAT Property

FONT Collection - BOLD, ITALIC, UNDERLINE Properties

Exercise 02b - Objectives Overview

Exercise 02b - Solution

Add Color To Cells, Inside and Out (4 Ways)

Range Properties Quiz

02 - Range Properties Quiz

The Cells Object

Intro To The Cells Object

Using The Cells Object and Practical Applications

Using Column Letters Instead of Numbers

Using Cells Positionally Within A Range

Affecting ALL Cells In A Worksheet

Exercise 03 - Objectives Overview

Exercise 03 - Solution

Using Range Object With Cells Object (To Affect Multiple Cells)

Cells Object Quiz

03 - Cells Quiz

Previous Lesson

What Is The Range Object and Your First Macro From Scratch

01 Excel VBA 101: Read and Write Cell Data with Range & Cells Objects
What Is The Range Object and Your First Macro From Scratch

Previous Lesson

Leave a Comment Click here to cancel reply.

You must be logged in to post a comment.

X

Username

Password

Remember me

Forgot Password?

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account