There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.

This part of the Excel VBA training series of blogs shows how to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.

Setting up a pattern of working time in a Project calendar is simple enough when your week runs from Monday to Sunday, but when you have an unusual working pattern setting up the calendar is a pain! This article explains how to use VBA to create a detailed calendar at the click of a button!