Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

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

Current Status

Not Enrolled

Price

$20.00

Get Started

Course Content

The Range Object
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 1 Quiz
Range Properties
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 1 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 1 Quiz
Lesson Content

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2025 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram