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.