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
SELECT Method
COUNT Property
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
Next Lesson

What Is The Range Object and Your First Macro From Scratch

  1. 01 Excel VBA 101: Read and Write Cell Data with Range & Cells Objects
  2. What Is The Range Object and Your First Macro From Scratch
Previous Lesson
Back to Course
Next Lesson

Leave a Comment Click here to cancel reply.

You must be logged in to post a comment.

closebarsangle-double-down
X

Forgot Password?

Join Us

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

Lost Your Password?
Register
Don't have an account? Register one!
Register an Account
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram