This example illustrates the difference between A1, R1C1 and R[1]C[1] style in Excel VBA.

To set up the macro security settings in Excel, execute the following steps.

The Macro Recorder, a very useful tool included in Excel VBA, records every task you perform with Excel.

Just like you can password protect workbooks and worksheets, you can password protect a macro in Excel from being viewed (and executed).

As a beginner to Excel VBA, you might find it difficult to decide where to put your VBA code.

This example teaches you how to swap two values in Excel VBA.

By default, Excel records macros in absolute mode. However, sometimes it is useful to record macros in relative mode.