Cell and Range References
Learn the four types of cells references: Relative, Absolute, Mix and Named
R1C1 Reference Style
In R1C1 style, Excel use numbers 1,2,3 for both columns and rows. The cell A1 is referred to as cell R1C1, cell A2 as R2C1, cell B1 as R1C2, cell B2 as R2C2 and so on.
External References to other worksheets and workbooks
Learn how to reference cells and ranges that are in different worksheets or workbooks.
VBA and Macros
Learn how to use VBA to develop macros to automate tasks and manipulate objects to control Office applications.
VBE - The VBA Editor
This tutorial walks you through the Visual Basic Editor (VBE) and shows you its most important features.
VBA Data Types
This tutorial explains the data types that VBA supports and the amount of memory each variable type requires. This tutorial also list the type-declaration characters.
Explaining VBa Data Types with Examples
In last tutorial we briefly discussed the VBA's built-in data types. Now we'll try to understand the each data type through examples.
Getting Started
Learn previous versions of Microsoft Excel
