How to use VBA to repurpose a built-in command in Word and Excel Your email has been sent The article, How to use VBA to update fields in a Word document shows you three ways to update fields: ...

Welcome, my friends, to the second installment of Macro Anatomy. In this episode we'll be going over some basic macro commands and I'll introduce some simple macros for you to learn and play with.

Have you ever found yourself stuck in the endless loop of repetitive tasks in Excel—manually formatting rows, cleaning up data, or applying the same calculations over and over again? It’s frustrating, ...

1) Open your 'Macro Window' ("U" Key by Default). 2) Click 'New Macro' 3) Name your Macro 4) Create a description of your Macro (optional) 5) Choose which Icon you want to use, this will be on shown ...