Mastering Excel Macros - IF Statements

by Mark Moore

Continue your macro journey by adding intelligence to your macro. In this lesson we cover how to write IF statements in VBA. The IF statement is the basic unit of logic in Excel programming. It gives your program the ability to 'think' and perform actions based on one or several conditions. Along with that topic, we review how to use the OFFSET function programmatically and the ActiveCell. As with all the other lessons, there is a sample workbook you can get from my website to follow along with the exercises.

19 pages, Kindle Edition

First published December 1, 2014

About the author

Librarian note:
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.

Reviews

[Pascal K Hayes · Rating 5 out of 5]

Simple. The learning is there for the taking.

5 because the lessons are designed to foster understanding and promote thought. If you knew nothing you can't help but know something now.