This video covers a number of VBA concepts, but primarily how to use:
- the FOR EACH NEXT loop
- the IF THEN ELSE structure
You will learn how to create and set variables
You will learn how to format cells based on the value in the cell - just like conditional formatting but using VBA.
You will learn how to perform calculations based on values on your worksheet using VBA.
------------------------