Variables

Hi Phil

A Variable is a name used to represent a value in VBA.

Variables are used to represent values that may change during the procedure and identify a unique location in memory.

The syntax used to declare a variable is

Dim/Public/Private VariableName [As type]. eg:

Public PivotSelection As Byte

Hope this helps

Carlos